Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Hyperlink by forms button
I used the macro recorder to record a hyperlink and the result was :
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="BSL%20PK/POST%20Project%20Reports" How can i have it run by a form button rather than adding the Hyperlink to the cell, then having to click on the cell for it to run ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Hyperlink by forms button
Try something like the following in the Click event of a Command Button on a
form: ThisWorkbook.FollowHyperlink "http://whatever" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Corey" wrote in message ... I used the macro recorder to record a hyperlink and the result was : ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="BSL%20PK/POST%20Project%20Reports" How can i have it run by a form button rather than adding the Hyperlink to the cell, then having to click on the cell for it to run ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Hyperlink by forms button
thanks Chip.
Perfect "Chip Pearson" wrote in message ... Try something like the following in the Click event of a Command Button on a form: ThisWorkbook.FollowHyperlink "http://whatever" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Corey" wrote in message ... I used the macro recorder to record a hyperlink and the result was : ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="BSL%20PK/POST%20Project%20Reports" How can i have it run by a form button rather than adding the Hyperlink to the cell, then having to click on the cell for it to run ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you create labels that hyperlink on forms | Excel Discussion (Misc queries) | |||
Command button on forms | Excel Discussion (Misc queries) | |||
how disable a button forms .. | Excel Programming | |||
button reuser on forms | Excel Programming | |||
key Press on Forms Button | Excel Programming |