In this video, I will show you how you can reuse macros in any workbook by saving these in the Personal Macro Workbook.
A Personal Macro Workbook is an Excel file (Personal.XLSB) that is created and saved in the XLSTART folder. This file opens whenever you start Excel.
So if you save any macro or custom function in this Personal Macro Workbook, it will make those macros available to all your Excel Workbooks.
In this video, I will show you how to create a Personal Macro Workbook and how to copy macros in it.
00:00 Intro
00:20 Creating a Personal Macro Workbook
03:00 Copy Pasting Macro Code in Personal Macro Workbook
04:55 Adding Macro to Quick Access Toolbar
06:05 Adding a New Tab in the Ribbon for Macros
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) https://trumpexcel.com/learnexcel/
✅ Free Dashboard Course https://bit.ly/freeexceldashboardc...
✅ Free VBA course https://bit.ly/excelvbacourse
✅ Free Power Query Course https://bit.ly/powerquerycourse
✅ Best Excel Books: https://trumpexcel.com/bestexcelbooks/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial