98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Medium Priority · Version 2007
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |