Can a hyperlink run a macro?

[Guest]

I have a sheet that contains total from different departments. I would like
to have the department name be a hyperlink that runs a macro to display the
breakdown of the total. Making the macro is no problem, but can I have the
hyperlink run it as if it were a button?

 

[Tod]

I found a good post that answers your question. Copy and
paste this into your browser's Address box:

http://groups.google.com/groups?q=excel+%
22hyperlink+to+run+a+macro%22&hl=en&lr=&ie=UTF-8&selm=%
23rQ4nXRqBHA.1964%40tkmsftngp07&rnum=1

tod

 

[ZipCurs]

Thank you. That did the trick. Is it possible to stop the hyperlink from
running?