Menu Page

[pc_user]

I'd like to make a menu page with buttons to jump between spreadsheets
of a workbook. I will turn off the tabs at the bottom in order to do
this, but I'm looking for code for my menu buttons to flip to each
spreadsheet.
Also to return to the menu from a specific spreadsheet, I'd like to use
a right click to jump back to the menu. Can someone help me with this.
I'm used to programming in MS Access, so programming in MS Excel is a
new venture for me.

Thanks,
PC

 

[Dave Peterson]

How about an alternative...

Create that index worksheet and put hyperlinks to A1 of each sheet.

And then put a hyperlink in A1 to go back to the index sheet.

If you freeze row 1 so that it's always visible, the user will be able to find
that hyperlink pretty quickly.