Excel provides you with a facility to store all your macros in a single workbook. The workbook is called Personal Macro Workbook - Personal.xlsb. It is a hidden workbook stored on your computer, which opens every time you open Excel. This enables you to run your macros from any workbook. There will be a single Personal Macro Workbook per computer and you cannot share it across computers. You can view and run the macros in your Personal Macro Workbook from any workbook on your computer.
Saving Macros in Personal Macro Workbook
You can save macros in your Personal Macro Workbook by selecting it as the storing option while recording the macros.
Select Personal Macro Workbook from the drop down list under the category Store macro in.
• Record your second macro.
• Give macro details in the Record Macro dialog box as shown below.
• Click OK.
Your recording starts. Create a table as shown below.
• Stop recording.
• Click the VIEW tab on the Ribbon.
• Click Macros.
• Select View Macros from the dropdown list. The Macro dialog box appears.
The macro name appears with a prefix PERSONAL.XLSB! indicating that the Macro is in the Personal Macro Workbook.
Save your workbook. It will get saved as an .xls file as the macro is not in your workbook and close Excel.
You will get the following message regarding saving the changes to the Personal Macro Workbook –
Click the Save button. Your macro is saved in the Personal.xlsb file on your computer.
No comments:
Post a Comment