98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Medium Priority · Version 2003
Nicola has attended:
Excel Intermediate course
PowerPoint Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Intermediate Advanced course
Excel Advanced course
Time Management course
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing all your workbooks QuicklyHold 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. |