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

preview_player
Показать описание
How to Save the VBA Macro Code Permanently in Excel without creating an add-in file...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.

►IMPORTANT NOTE:

1. PERSONAL.XLSB file is located here... C:\Users\UserName\AppData\Roaming\Microsoft\Excel\XLSTART

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.

#MicrosoftExcel #MSExcel

-------------MACRO CODE RELATED-------------

--------------------Related Videos-------------------

--------------------------Follow us-----------------------

Keep Watching, Keep learning...!!!

-~-~~-~~~-~~-~-
Please watch: "How to Use Macro in Excel | How to Create Macros in Excel | Macro Record kaise kare | Macro in Excel"
-~-~~-~~~-~~-~-
Рекомендации по теме
Комментарии
Автор

0:50 Paste "here", ---- Where's (here)?

freepilot
Автор

Hi can you help me i want to merge several excel files in on excel in on sheet with header

sivadilip