View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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