Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I create a macro to assign and open a hypenlinks?
Thanks. Maperalia |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
From the vba help file:
The following example activates the hyperlink for shape one. Worksheets(1).Shapes(1).Hyperlink.Follow NewWindow:=True A range or worksheet can have more than one hyperlink. Use Hyperlinks(index), where index is the hyperlink number, to return a single Hyperlink object. The following example activates hyperlink two in the range A1:B2. Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow "maperalia" wrote: How can I create a macro to assign and open a hypenlinks? Thanks. Maperalia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
create a macro to automatically open excel | Excel Discussion (Misc queries) | |||
create a macro to automatically open excel another excel file | Excel Discussion (Misc queries) | |||
How to create a macro to open a new application | Excel Discussion (Misc queries) | |||
open up an excel program with an auto open macro | Excel Programming |