VBA - Personal Macro Workbook (in Excel)
Learn how to control the scope of reach of macros using the Personal Macro Workbook (PERSONAL.xlsb)
QAT Customization - Ultimate Guide
• Microsoft Office - Quick Access Toolbar
Sort Sheets Macros
• Microsoft Excel - Sort Sheets Alphabetically
00:03 Local vs. Global Macros
01:04 Personal Macro Workbook
01:37 PERSONAL.XLSB Location
02:05 Accessing the Hidden APPDATA Folder
02:56 Examine an existing Personal Macro Workbook
03:49 Creating the Personal Macro Workbook (PERSONAL.xlsb)
04:08 Creating an "Empty" Macro
04:49 Viewing the PERSONAL.xlsb Code
05:45 Renaming Modules
06:04 Launching Macros Without U.I. Customization
06:20 Customizing the Quick Access Toolbar (QAT)
06:29 Unhiding the PERSONAL.xlsb File
07:09 Saving Personal Macro Workbook Code
07:40 Finding Free Code Examples