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.
