Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
|
|
|
The UK's most regular 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. |
Macros
Resolved · Low Priority · Version 2007
Reply Fri 10 Oct 2008, 16:24Delegate Jesse said...
Jesse has attended:
Excel Intermediate course
Excel Advanced course
Macros
how do you create a macro so you enter data on onme file, and it is entered in a different way on several other files?
For upcoming training course dates see: Pricing & availability
RE: macros
Hello Jesse
Thank you for your question and welcome to the forum.
When you go to run a macro, you have the option of selecting Macros in: All Open Workbooks.
That way if you have created and saved a macro in one workbook you should be able to access and run it in other workbooks, provided the workbook you created it in is open at the time when you want to run the macro.
I hope this helps to answer your question.
Amanda
|