Forcing Using of Button to Move Between Worksheets

[03856me]

Excel 2007 - I currently have a sheet "Main" that contains many buttons for selecting reports, data entry userforms, etc. When the user selects one of these buttons the appropriate worksheet is unhidden and becomes the active worksheet. Each worksheet contains an "Exit" button with a macro to return to the main menu and also hides the active sheet again.

Question 1: Is there a way to force the user to only be able to use the "Exit" button to go back to the main menu? I do not want them to be able to use the tabs across the bottom of the window.

Question 2: Is there a way remove the option of closing/saving the file except using the button on the Main page to do so? My desire is to always have the file on the Main page when the file is closed/opened.

 

[BrianB]

1. Hide the tab
2. have a workbook.open macro to activate the sheet required.
Good for initial setup too.