You might wonder how to save the macros that are created. In this context you need to know-
• Storing a macro
• Saving a macro enabled file
As and when you create a macro, you can choose where to store that particular macro.
You can do this in the Record Macro dialog box.
Click the box - Store macro in. The following three options are available-
• This Workbook.
• New Workbook.
• Personal Macro Workbook
• Storing a macro
• Saving a macro enabled file
As and when you create a macro, you can choose where to store that particular macro.
You can do this in the Record Macro dialog box.
Click the box - Store macro in. The following three options are available-
• This Workbook.
• New Workbook.
• Personal Macro Workbook
This Workbook
This is the default option. The macro will be stored in your current workbook from where you created the macro.
New Workbook
This option, though available, is not recommended. You will be asking Excel to store the macro in a different new workbook and mostly it is not necessary.
Personal Macro Workbook
If you create several macros that you use across your workbooks, Personal Macro Workbook provides you with the facility to store all the macros at one place.
No comments:
Post a Comment