View Single Post
  #2 (permalink)  
Old March 26th, 2006, 06:40 AM
wromee wromee is offline
Registered User
 
Join Date: Mar 2006
Location: Sydney, NSW, Australia.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Following line in the "on click" event of your command button will take you to Sheet2. (If this is what you were looking for . . .)

Sub Button1_Click()
    Sheets("Sheet2").Select
End Sub