autorun macro by pressing hyperlink, help
 

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

autorun macro by pressing hyperlink, help
 

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

--
Regards,
Tom Ogilvy

"keso" wrote in message
...
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