Run Hyperlink by forms button

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

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 ?
 
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)
 
thanks Chip.

Perfect

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add hyperlink without changing the cell formating 6
Hyperlinking cells and macros 2
Create Hyperlink in VBA 7
Help with loop 1
Insert Hyperlink 4
Hyperlink macro for personal.xls 5
Still struggling... how make a hyperlink not hot! 10
Adding a hyperlink to a shape 1

Back
Top