How to initiate macros in user-friendly fashion
I have created several macros that I want someone else, who is not that
well-versed, to be able to run easily, over and over. I am afraid to just
assign keyboard controls with a letter (such as cntrl-a), or such things, as
they might inadvertently trigger a macro when they are just typing stuff in.
So, something I recall seeing, but don't recall how to set-up, is that the
name of selected (though not all, I hope) macros appear on the Tools
dropdown within EXCEL. Even better, if easy to do, would be the clickable
buttons you can put on a worksheet and click to initiate macros, - but if
that's tricky, I don't need that now.
Can someone tell me how this is done, please?
Thanks much
Dean
|