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?

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

-----Original Message-----
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?
.

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

"Tod" wrote:

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

-----Original Message-----
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?
.