Macro Storage

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses in · Excel training courses · VBA courses London UK

Resolved · Low Priority · Version 2003

Macro Storage

Lincoln has attended:
Excel VBA course

by - delegate Lincoln [1 post] (2008 Aug 7 Thu, 16:28) Reply

Is there any way to store macros in both the workbook and personal directory from the outset?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Macro Storage

by - trainer Carlos gold contributer [473 posts] (2008 Aug 8 Fri, 16:02) Reply

Hi Lincoln

The short answer is No.

The system will only save the macro in one place at a time. You need to copy the macro to the other document yourself.

Regards

Carlos

· Excel Macros for the Non-Programmer
· From the Classroom to the Corporate World
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Features and Functions for Accountants
· Training Budgets In A Bad Economy

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

Excel tip:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart’s elevation and rotation to make it more visually appealing. To do this, click the chart and select 3-D View from the Chart menu. The 3-D View dialog box will appear.

The elevation is the height you view the chart from. Click the arrows to the left of the preview picture or enter a value (something between 90 and –90) in the Elevation field to adjust the elevation.

Rotation is the rotation of the plot area around the z-axis. Click the arrows below the preview picture or enter a value (something between 0 and 360) in the Rotation field to adjust the rotation

View all Excel hints and tips