David has attended:
Excel Advanced course
Excel
Hello,
in Excel 2003 you could add custom buttons, assign macros to them, which I used to set up a suite of custom formatting buttons which I could access anytime from my personal workbook.
I can't work out how to do this in Excel 2007. I assume that if at all I would be able to add buttons to the quick access toolbar and assign macros to these buttons but can't work out how to add custom buttons. Could you advise if it is possible, and if so , how?
thanks
RE: Excel
Hi David
Thanks for your question. You are right in saying that the Quick Access Toolbar (or QAT) is the place to add buttons for your macros. To set this up click on the small double arrow pointing down at the end of the QAT. From the list that appears choose "More Commands". You will see at the top of the dialogue box there is a drop down currently labelled "Popular commands" Click on this and from the drop down you will see there is a Macros item in the list. Choosing this will allow you to pick your macros and add them individually to the QAT.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
