Linking worksheets by buttons.

M

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.
 
K

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


Code:
--------------------

If ToggleButton1.Value = True Then
ToggleButton1.Caption = "HIDE FORM"
Else
ToggleButton1.Caption = "SHOW FORM"
End If
If Worksheets("Sheet1").Visible = True Then
Worksheets("Sheet1").Visible = False
Else
Worksheets("Sheet1").Visible = True
End If
With Me.ToggleButton1
If .Value = False Then
.ForeColor = &H0
Else
.ForeColor = &HFF&
End If
End With

--------------------


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
 
Top