Excel 2007 - Macros

The UK's most regular instructor-led training courses.
Training information: excel+training · Advanced.excel · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel 2007 - Macros

Adrian has attended:
Excel Advanced course

by - delegate Adrian [1 post] (2008 Mar 12 Wed, 15:30) Reply

How to change the appearance of the Macro toolbar button?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Excel 2007 - Macros

by - trainer Pete platinum contributer [864 posts] (2008 Mar 27 Thu, 09:25) Reply

Hi Adrian,
Welcome to the forum, Thank you for the post, In answer to your question, this option is not available in Excel 2007, you can however place a view Macros button on your quick access toolbar or use the keyboard command ALT+F8 (Function 8) key, these commands will open the Macro dialog box where you can choose the Macro and click Run.
If however you are using Office 2003 the answer would be to use the Customise Toolbar button options, select the button to change and from the menu options choose a new button or customise the button by creating your own design, I hope that answers your question, best regards Pete.

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Reporting and Analysis with Excel
· How to Create Better Excel Spreadsheets: Part Four
· Prepare for your MOS Certification with MS Excel Courses
· Fun Things I've Done With Excel

Please browse our web site to find out more about
excel+training and other Microsoft training courses.

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Rate this page: