How to Save Macro Code Permanently in Excel… as part of the programme
We always face a problem using the VBA macro code, that it only works in the Open Excel workbook. Because when we open a new excel file, our saved macro code not showing there. If you want the macro code permanently stored in Excel, as part of the programme. So that it is available every time when you open a new Excel file.
Then in this video, you will learn to store your favorite macro code permanently in MS-Excel. So watch this video complete till the end.
- PERSONAL.XLSB file is located here… C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART
- AppData is a hidden folder If you don’t know how to unhide it then watch this video: How to Show hidden files & folders in windows 10.
- You can also Share PERSONAL.XLSB file with your Friends & Colleague… You just need to copy it from the location & then paste PERSONAL.XLSB in the same location.