tbablue
Active Member
- Joined
- Apr 29, 2007
- Messages
- 488
- Office Version
- 365
- Platform
- Windows
Sheets("Top Level").Range("top_list").Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"", ScreenTip:="CLICK TO PROGRESS"
I'm trying to render all items in named range 'top_list' as hyperlinks. I don't want the wizard that happens with keyboard shortcut ctrl+k [insert hyperlink], I just want to use the hyperlinks as triggers for different macros; address = ""
How is my code [macro-recorder] amended so that it only applies to the cells in 'top_list'?
"", ScreenTip:="CLICK TO PROGRESS"
I'm trying to render all items in named range 'top_list' as hyperlinks. I don't want the wizard that happens with keyboard shortcut ctrl+k [insert hyperlink], I just want to use the hyperlinks as triggers for different macros; address = ""
How is my code [macro-recorder] amended so that it only applies to the cells in 'top_list'?
