| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Hyperlink using macros
Does anyone know how to open a hyperlink without using your mouse?
I've tried a couple of macros but I can't get them to work. I am inexperienced with Macros (especially the VBE ones) Any help would be MUCH appreciated as it would save me a great deal of time. Thank you, Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a Hyperlink using macros
Look at the followhyperlink command.
-- regards, Tom Ogilvy " wrote: Does anyone know how to open a hyperlink without using your mouse? I've tried a couple of macros but I can't get them to work. I am inexperienced with Macros (especially the VBE ones) Any help would be MUCH appreciated as it would save me a great deal of time. Thank you, Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a Hyperlink using macros
Lets say there is a hyperlink in cell D7:
http://www.microsoft.com then: Sub hypergoer() ActiveWorkbook.FollowHyperlink Address:=Range("D7").Value End Sub -- Gary''s Student - gsnu200745 " wrote: Does anyone know how to open a hyperlink without using your mouse? I've tried a couple of macros but I can't get them to work. I am inexperienced with Macros (especially the VBE ones) Any help would be MUCH appreciated as it would save me a great deal of time. Thank you, Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error on opening a hyperlink to a url | New Users to Excel | |||
| Opening Hyperlink | Excel Programming | |||
| Hyperlink to rtf only opening in MS Word | Excel Discussion (Misc queries) | |||
| Hyperlink not opening | Excel Discussion (Misc queries) | |||
| Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Linear Mode
