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


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=534653