Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Macros

Resolved · Low Priority · Version 2007

Reply Thu 27 Nov 2008, 16:54Delegate Tom said...

Tom has attended:
Excel Advanced course

Macros

Is it possible to transfer macros from one workbook to another, if they have not been saved in the personal macro workbook?

For upcoming training course dates see: Pricing & availability

Reply Thu 4 Dec 2008, 10:28Trainer Mark said...

RE: Macros

Hi Tom
Thanks for the post - sorry for not getting back to you before

There is a way of using a macro from another workbook, what you will need to do is open the workbook that the macro is in - then go into the macro by macro view or, ALT F8 then click edit

Then copy the data from there to the other file in the same place

Hope this helps you

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel articles

· How To Add A Second Axis To An Excel Line Chart
· How To Print Worksheets In Excel
· How To Split A Stacked Chart In Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Save time with Microsoft Excel

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

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips