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 » basic excel training - Macro workbook
basic excel training - Macro workbook
Resolved · Low Priority · Version Standard
Macro workbook
When we created a macro yesterday we used it two ways. One we created a shortcut key in the "This workbook" and then we next attached it to a personal toolbar and used it from a button with the macro assigned to it Another option when using the shortcut key was "Personal Workbook" - I often need the same macro in different workbooks so would it be better to store my macros in a personal workbook - how does this then work?
RE: Macro workbook
By storing the Macro in a personal workbook, you will be able to use the macro across all new and existing spreadsheets.
RE: Macro workbook
Would that mean that I would always need to remember to open my personal workbook when I open excel and if so can I automate this?
RE: Macro workbook
No it will open with the application. For example, if you created a macro button on the toolbar, it will stay there everytime you open up Excel.
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:Sorting data stored in rowsPrimarily Excel is set up to sort data that is stored in columns rather than rows. |