Save to original number of sheets in file

[greatscottbattman]

Got a spreadsheet that opens with 1 worksheet (like a dashboard). On this worksheet, there are a few buttons with macros assigned to them. These macros open a number (ranges, depends on button) of hidden sheets as a group. The user then has the ability to change and save the data and close. When the next user goes in, I'd like to have the workbook open as 1 worksheet and the rest of the sheets as hidden. Is there a way I could make this happen.
Any advice would be greatly appreciated.

 

[daverunt]

Have a look at Workbook open events.
Placed in the 'ThisWorkbook' module

http://www.excelforum.com/excel-programming/492269-hide-sheet-using-workbook-open-event.html

 

[greatscottbattman]

Perfect. thank you