Macros

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

Resolved · Low Priority · Version Standard

Macros

Sunil has attended:
Excel Advanced course

by - delegate Sunil [1 post] (2008 Feb 8 Fri, 15:58) Reply

How do you export marcos into different workbooks?

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: Macros

by - trainer Pete platinum contributer [864 posts] (2008 Feb 8 Fri, 22:04) Reply

Hi Sunil, Thank you for the post, In answer to your question, rather than trying to export the macro to different workbooks you should save the macro to the Personal Macro Workbook which will make it available to all workbooks opened on that computer. Hope that helps, best regards Pete

RE: Macros

by - trainer Pete platinum contributer [864 posts] (2008 Feb 8 Fri, 22:04) Reply

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Tap the Power of Recorded Macros with MS Excel Courses
· Tips to Facilitate Printing of Excel worksheets
· Tips for Transitioning to Excel 2007

Please browse our web site to find out more about
microsoft-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: