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).

--
Regards,
Tom Ogilvy

"keso" <keso@softhome.net> wrote in message
news:dtkdu6$27r$1@ss405.t-com.hr...
> 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
>
>