View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 363
Default 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 ?