Excel macro button
Excel macro button
(OP)
I have never written a macro before. I would like to start to learn how macros work. I used the macro record button to clear certain cells. I can go into the macro dropdown list and click run and the macro works perfect. I want to know how to add a button to run the macro vs going in the toolbar and clicking run every time. Can anyone explain how to insert these and name these buttons? Could not find this information in the help menu! Also I have attached an example so you can see the macro I recorded.
Thanks in advance!
Thanks in advance!





RE: Excel macro button
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel macro button
You can even assign macros to "shapes" as well. An old trick is to create a transparent rectangle (without border) and lay it over a cell. Assign a macro. Now you can click on the cell to run the macro. I use this a lot for the purpose of clicking on the cell in order to open a page linked to that cell.
RE: Excel macro button