Create hyperlink TO macro?

[endly]

Hello,

Is there a way to create a hyperlink on a worksheet to an individual macro?

I'm wondering if there is a quicker way to access common ones. I know I can create a shortcut key but would like a hyperlink on my "Dashboard".

Thank you.

[vamosj]

Hope this helps.


Right click on ribbon bar
Customize Ribbon
Right dropdown menu at bottom create new tab
Rename as needed
Left dropdown menu select macros
Move macros you want on the ribbon bar to the newly created tab.

[FDibbins]

You could add a shape to the WS (any shape) and link the macro to that

1. Insert Tab/Shape/pick 1/click on teh sheet where you want it, and drag to the size you want
2. Right-click into the shape/select Assign Macro
3. select the macro you want
4. while still in the "right-click" menu, click Edit Text and give teh shape a name

Now, when yoy click that shape, your macro should run

[endly]

Great. Thank you!

[FDibbins]

Happy to help, thanks for the feedback