Form as a navigation Tool

[Derrick T. Davidson]

Hi All:
I am new to forms and have been experimenting with adding forms and manipulating data.

My question here; is there a way to hide the myriad of worksheets that I have and simply display a user form with button to navigate to where the user wants to be. My ideal solution would be only the user form would open when the workbook is opened, the user can then click on a button i.e. Credit and the user form is no longer visible but the worksheet "Credit" is. When the close button on the "Credit" worksheet is clicked then it goes back to the Start navigation form and the user can either click another worksheet to display and enter data or view the results. Upon completion the user can click an Exit button to close the workbook.

I know this is easy in Access but my new boss only likes Excel.

Thanks in anticipation

[AliGW]

Hiding the worksheet tabs can be done via options. Any cell can become a button by adding a hyperlink, so you can easily create a dashboard sheet that will behave like a menu. For instance:

=HYPERLINK("#'Data Collation Sheet'!A1","DATA")

This will take you to a sheet called Data Collation Sheet when clicked, and the cell will say DATA. You can then colour the cell to make it look like a button and hide the gridlines on the sheet. This is just one way of doing it, but might suit your purposes.