How do I initiate a macro directly in a worksheet?
All you need is a Command Button. Click on "View/Toolbars/Control Toolbox.
You will see, among others, the Command Button icon. Click it and click on
the sheet where you want the button. When you double-click the button a
Macro will be set up for you to place your code in. If you right-click the
button and choose "Properties" you can change the Caption on it etc.
--
Best wishes,
Jim
"AMMPro" wrote:
I would like to click on a cell and initiate a macro. Is it possible?
|