Hi,

I use hyperlinks to navigate around a spreadsheet instead of command
buttons. But how can I get a hyperlink to show a userform or run a
macro? Is this possible? If so, how?

kind regards,
Matt

Don't know about userforms, but there are two ways to get a hyperlink to run
a macro:

1. Have the hyperlink jump to a certain cell in the worksheet and then have
a worksheet event macro detect the selection and run your code.

2. Use a Workbook_SheetFollowHyperlink macro you call your macro. This
works with hyperlinks implemented with Insert Hyperlink and not the
hyperlink function.
--
Gary''s Student - gsnu2007j


"MJKelly" wrote:


Hi,

I use hyperlinks to navigate around a spreadsheet instead of command
buttons. But how can I get a hyperlink to show a userform or run a
macro? Is this possible? If so, how?

kind regards,
Matt

Thanks for that. I suppose I could just use a userform.show in the
macro anyway.

Great,
Matt