Command Button

I

inspirz

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
 
D

Dave F

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
 
Top