View Single Post
  #1 (permalink)  
Old March 22nd, 2006, 09:07 AM
sriramus sriramus is offline
Registered User
Join Date: Nov 2005
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default navigate b/w worksheets with command button

Hi All,

Can any one help me to write a vba code to navigate between worksheets with a command button.

I tried with hyperlink method but i suppose i was going wrong in writing the code.

Any help or suggestion is highly appreciated.

Thanks in advancePrivate Sub CommandButton1_Click()

    ActiveWorksheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "Sheet3!A1", TextToDisplay:=""
End Sub

Reply With Quote