Forum home » Delegate support and help forum » Microsoft Excel Training and help » best training excel vba - Excel 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. |
best training excel vba - Excel macros
Resolved · Low Priority · Version Standard
Reply Wed 10 Oct 2007, 16:23Delegate vanessa said...
vanessa has attended:
Excel Advanced course
Excel macros
is it possible to have some macros already prepared
For upcoming training course dates see: Pricing & availability
RE: excel macros
Hi Vanessa, Thanks for the post, if you have created macros in one workbook and you wish to have them available in another, other than creating your macros intially with the option Personal Macro Workbook chosen from the "Store Macro in" text box, which makes them available every time you open any workbook, you can copy them from one workbook to another by following these steps:
1. Open the workbook that contains the module you want to copy and the workbook you want to copy the module to.
2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
3. On the View menu, click Project Explorer.
4 Drag the module you want to copy to the destination workbook.
|