Linking worksheets by buttons.

[Moggie]

Hi,
I am new to all this excel stuff so this may seem a simple question.
I am trying to link together worksheet tables by the use of a n onscreen visual button. So by simply clicking on a certain cell/button it will take the user to my desired worksheet.

Any Ideas?!?!?!?

Cheers.

[keithl816]

If you want to designate a cell to open another sheet you could Hyperlink to that sheet.

Right click cell in the dropdown pick Hyperlink|Pick Your Workbook then Click Bookmark|Select sheet desired.

Or you could create a toggle button
Go into design mode place a togglebutton onto the sheet and right click, in the dropdown click view code. place this code between Private sub Togglebutton1_Click() and End Sub

Please Login or Register  to view this content.

Change sheet1 to the name of the sheet you are wanting to open. Also make sure to hide the sheet before clicking the button.

hope this helps