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

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

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

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

I am getting an error message that says can not execute code in break mode
what does this mean?
--
Thank you, Brenda


"Dave Peterson" wrote:

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

It sounds like you started the macro and paused it.

Then tried to restart it.

Inside the VBE, you can click on Run|Reset (on the toolbar).

Then start it again.

Brenda wrote:

I am getting an error message that says can not execute code in break mode
what does this mean?
--
Thank you, Brenda

"Dave Peterson" wrote:

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


--

Dave Peterson

Hi,

Actually, you can use a formula to select a sheet. If what Brenda means is
that the sheet tabs are hidden but not the sheets, this will work. For
example, a formula such as =Sheet2!A1 in cell B1 of Sheet1 would allow the
user to get to sheet2 by selecting cell B1 and pressing Ctrl+[

--
Thanks,
Shane Devenshire


"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