excel button hyperlink 1

[SQLScholar]

I need a button on a sheet to go to a specific URL with the default browser. I cant hyperlink a button (greyed out) why???

How can i do this?

TIA

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[VulcanJedi]

Paste this code in the code for you button:
for example:

public sub commandbutton1_click()
ActiveWorkbook.FollowHyperlink Address:="

http://www.yahoo.com",

NewWindow:=False, AddHistory:=True
end sub


hope this helps Tranpkp

 

[SQLScholar]

Thanks....... exactly what i required.

Cheers

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!