Sheets("NomeFoglio").Visible = True oppure False
Private Sub Workbook_Open() Dim i As Integer Dim obtOptionbutton As OLEObject Dim osh As Worksheet Set osh = ThisWorkbook.Worksheets(1) For Each obtOptionbutton In osh.OLEObjects If TypeName(obtOptionbutton.Object) = "OptionButton" Then obtOptionbutton.Object = False End If Next For i = 2 To Sheets.Count Sheets(i).Visible = False Next i End Sub
Private Sub OptionButton1_Click() Dim i As Integer Application.ScreenUpdating = False For i = 2 To Sheets.Count Sheets(i).Visible = False Next i Sheets("Terreni").Visible = True Sheets("Ausiliari").Visible = True Sheets("Offerta").Visible = True Application.ScreenUpdating = True End Sub
Private Sub OptionButton2_Click() Dim i As Integer Application.ScreenUpdating = False For i = 2 To Sheets.Count Sheets(i).Visible = False Next i Sheets("Terreni").Visible = True Sheets("Ausiliari").Visible = True Sheets("STAMPAOFFERTA").Visible = True Application.ScreenUpdating = True End Sub
Private Sub OptionButton3_Click() Dim i As Integer Application.ScreenUpdating = False For i = 2 To Sheets.Count Sheets(i).Visible = False Next i Sheets("Terreni").Visible = True Sheets("Ausiliari").Visible = True Sheets("DEF").Visible = True Application.ScreenUpdating = True End Sub