I will have 12 tabs. I want to have 12 buttons that will turn on and off these tabs
Example
Sub tab1()
'
' tab1 Macro
'
'
Sheets("tab1").Select
Sheets("Sheet3").Visible = True
Sheets("tab2").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab3").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab4").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab5").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab6").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab7").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab8").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab9").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab10").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab11").Select
ActiveWindow.SelectedSheets.Visible = False
Sheets("tab12").Select
ActiveWindow.SelectedSheets.Visible = False
End Sub
By the way, I love this forum. I'm learning a lot. Only yesterday I didn't know how to do anything except record keystrokes. Now I'm writing code.
Bookmarks