Command Button
 

Hi,

I created a "Command Button" in an excel worksheet and I want to be able to
click so that it sends me to another tab in my spreadsheet. How do you do
that?

Mike

Command Button
 

Create a macro in a module in the VBE with the following code:

Sub Macro3()
Sheets("YourSheet").Select
End Sub

Where YourSheet is replaced with the name of the sheet you want to navigate
to. Note the double quote marks need to stay.

Then assign that macro to the button.

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"inspirz" wrote:

Hi,

I created a "Command Button" in an excel worksheet and I want to be able to
click so that it sends me to another tab in my spreadsheet. How do you do
that?

Mike