If you're using macros in Microsoft Excel, you may have noticed that the toolbar buttons for your macros disappear after you save and close the workbook. This can be frustrating, especially if you use the same macros frequently. Fortunately, there's a way to prevent this from happening.
When you create a macro in Excel, the default behavior is for the toolbar button to only be visible when the workbook containing the macro is open. This is because the button is linked to the macro, which is stored in the workbook. Once the workbook is closed, the button is no longer accessible.
However, there is a way to change this behavior so that the toolbar button for your macro remains visible even when the workbook is closed. To do this, you need to create an add-in file and store your macro in that file. Then, when you open Excel, the add-in will load automatically and make your toolbar button available.
Creating an add-in file is easy. Just follow these steps:
Once you've created your add-in file, you can move your macro into it. To do this: