Take a closer look at how the shortcut works: First, the Alt key activates the ribbon shortcuts.
#Shortcut to save as xlsb how to#
Also read: How to Remove Macros From an Excel Workbook How to Use Macros Stored in Personal Macro Workbook? The above steps would save the macros you want to reuse in the Personal Macro Workbook.
#Shortcut to save as xlsb code#
Here are the steps to copy macros in the Personal Macro Workbook: Once the PERSONAL.XLSB file is created and saved, you can copy macros that you wish to reuse again. How to Copy Macros in the Personal Macro Workbook? When this is done, Excel will create and store the PERSONAL.XLSB file in the start folder, where it would automatically open in the backend whenever you open Excel. Doing this would show a prompt as shown below: Now that the Personal Macro Workbook is created, you need to Close all the open workbooks. This was done to create the Personal Macro Workbook. Since we did absolutely nothing, the macro has no code in it. Note: If you can’t see the developer tab in the ribbon, here are the steps to enable it.ĭoing this would create a new workbook with the name PERSONAL.XLSB and store the macro in this workbook.