How to Save Macro Code Permanently in Excel… as part of the programme

Published by Get eSolutions on

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. 

getesolutionsIMPORTANT NOTE:
  1. PERSONAL.XLSB file is located here… C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART
  2. 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.
  3. 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.
WATCH MORE VBA MACRO CODE RELATED VIDEOS IN MS-EXCEL:

3 Comments

How to Print Odd Or Even Pages In Excel 2007, 2010, 2013 & 2016 | Get eSolutions · March 21, 2019 at 2:41 pm

[…] ⇒ How to Save Macro Code Permanently in Excel… as part of the programme […]

Change Case in Excel without Formula | How to change Lowercase to Uppercase in Excel | Get eSolutions · March 21, 2019 at 2:44 pm

[…] ⇒ How to Save Macro Code Permanently in Excel… as part of the programme […]

Convert Number to Words in Excel 2010,2013 & 2016 Without using Macro Code | Spell Number in excel | Get eSolutions · March 21, 2019 at 2:45 pm

[…] ⇒ How to Save Macro Code Permanently in Excel… as part of the programme […]

Leave a Reply

Title