Macros

Hi Cecilia

Thanks for getting in touch. You can assign a macro to all manner of objects in Excel. Most of the time you can find it by right-clicking and object and choosing Assign Macro, selecting your macro from the list and clicking OK.

For example, you can insert any of the drawing shapes from the Insert menu. Once drawn right click and follow the process above.

For a true button, you need to first enable the Developer toolbar (Office button, Excel Options, check the box marked "Show the Developer tab in the ribbon"). On the Developer toolbar, click Insert and click the command button. Draw it on your worksheet and right-click as above.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector