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 » best training excel vba - Excel macros
best training excel vba - Excel macros
Resolved · Low Priority · Version Standard
vanessa has attended:
Excel Advanced course
Excel macros
is it possible to have some macros already prepared
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.
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:Using basic functions without doing formulasWhen you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums. |