Hyperlink to code
Select a cell for the hyperlink.
InsertHyperlinkPlace in this document.
Point to the sheet and cell you have selected and OK
Right-click on the sheet tab and "View Code".
Paste this event code into the module.
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
macroname
End Sub
Gord Dibben MS Excel MVP
On Mon, 6 Oct 2008 10:19:01 -0700, Daniel Bonallack
wrote:
Following on from my last post, what I would really like is
- to have a hyperlink-type text in a cell, so that when you mouse over it,
it becomes a hand icon
- but instead of linking this to a file or webpage, I want it to run a maco.
Is this possible?
Thanks
Daniel
|