autorun macro by pressing hyperlink, help

[keso]

Dear all,

I have a hyperlink on one cell that activates another worksheet. I'd like to
do the following:

By pressing that hyperlink I want to autorun a macro that will do some
changes in second worksheet.
Can this be done?

Thanks,
Keso

 

[Tom Ogilvy]

Look at the FollowHyperlink Event for the sheet containing the hyperlink.
(xl2000 and later).