View|Toolbars|check Forms

Brenda wrote:

I am using 2003 excel where would i find the forms button?
--
Thank you, Brenda

"Otto Moehrbach" wrote:

Brenda
A formula won't help you. A formula can't select a sheet nor
hide/unhide one. If you have a hidden sheet, say it's named "TheSheet", and
you want a button on some other sheet to unhide and select that hidden
sheet, then use a Forms button. You can use a Control Toolbox button but a
Forms button is easier. First you have to have a macro that would be
triggered by clicking on that button. The following macro does that:
Sub UnhideTheSheet()
Sheets("TheSheet").Visible = True
Sheets("TheSheet").Select
End Sub
Once you have placed this macro in a module in your file, go back to your
sheet (the sheet that will have the button). Click on View - Toolbars -
Forms. A little toolbar pops up. Find the tool button. Click on it. Move
your cursor to where you want the button, then hold the left mouse button
down and draw in the button. Once you do that you will get a pop-up that
asks you to select the macro to assign to this button, and the pop-up will
display all the macros available. Find the above macro name
"UnhideTheSheet", click on it and click OK. That's it. Come back if you
need more. HTH Otto
"Brenda" wrote in message
...
I am totally new at using the comman button. I have an excel spreadsheet
that
i have created and there are 4 other tabs at the bottom however i would
like
to have on the main page a Command button (i think that is what i would
need)
so that when a person clicks on that button it will take them to the tab
at
the bottom that i have now hidden. I guess i have two questions 1. Is the
command button what i need and 2 i have no clue how or where to even enter
the formula or what formula to use please help...
--
Thank you, Brenda




--

Dave Peterson