Thread: COMMAND BUTTON
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default COMMAND BUTTON

First and most important you tap the caps lock key to stop typing in capitals
then you do this

Right click the button and view code and then paste this in

Private Sub CommandButton1_Click()
Sheets("Sheet1").Select
End Sub

change the name of the sheet to the one you want.

Mike

"BOB" wrote:

I KNOW THAT THIS IS EXTREMELY BASIS, BUT I'M NEW SO PLEASE FORGIVE ME.
BUT....I NEED TO SET UP A COMMAND BUTTON TO MOVE TO A DIFFERENT TAB. HOW DO
I DO THAT? I HAVE THE BUTTON, BUT NOT SURE WHAT TO DO AFTER THAT.