From: ZipCurs on
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?
> >.
> >
>