Adding a hyperlink to a command button

[Roopen]

Hi All,

Maybe a very easy question... How do I add a hyperlink in a command button?

Any help appreciated

(Excel 2003)

 

[JamesW]

Hi,

Take a quick look here:

http://www.mrexcel.com/forum/showthread.php?t=51318

 

[Roopen]

Forgive me... All i want to do is add a hyperlink to a command button... So, I have various tabs and I want the command to go to the tab that is assigned.

Dont see how the link helps me...

 

[JamesW]

I thought you meant a website hyperlink.

Do you mean like this:

Private Sub CommandButton1_Click()
    Sheets("Sheet2").Activate
End Sub

 

[Roopen]

Hi James,

Your a gem... Works an absolute treat !!!!

I should have been a lot clearer so apologies for that

Thank you....