macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Macros

resolvedResolved · Medium Priority · Version 2003

Macros

When setting up a macro, if I want to access it on any Excel worksheet how do I save it?

RE: Macros - Macro availability in more than one file

Dear Nicola

Thank you for attending Excel Advanced Course. I hope you enjoyed the course and it was both enjoyable as well as informative!!

There are two possible solutions to the query you have asked. The first one is as follows:

Step 1: Choose [b]Tools > Macro > Record New Macro

RE: Macros - Macro availability in more than one file

Thanks Raj.

Also I run alot of reports from a different application that we use and import the information into Excel. I then format and delete rows and columns that I dont need to make the information more presentable.
On one report that I run I was thinking about setting up a Macro to help me format things quicker.
I delete rows where it has totaled sections, but I want it as one document, however the amount of rows between each section differs from week to week. Can I still use the Macro becuase it will delete that information, or will it always delete the specific row??

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips


Server loaded in 0.09 secs.