How to choose from multiple tabs

[oooHAARRooo]

I have a question to ask some of the brilliant minds in here

I have a large Excel document with a lot of tabs (inserted spreadsheets).

I would like to make a front page were the user have a choice of 4 buttons.

If you press one of the buttons, only some of the tabs should be visible. If you press one of the other button other pages should be visible. When I say visble I mean that the pages that are interesting for one button should show on the tabs menu the others should be hidden !

 

[Michael M]

Hi and welcome to the Board
After you have created the buttons, you can simply record the macro to slect which sheets to hide.
Then, right click on the button and assign the appropriate macro.
Here's a sample of recorded code to hide for example Sheets 2 & 3

Sub Macro1()
Sheets(Array("Sheet2", "Sheet3")).Select
    ActiveWindow.SelectedSheets.Visible = False
End Sub