Thread: Command Button
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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