0:00
A personal macro workbook is a hidden Excel file named personal.xlsb that stores macros or VBA code
0:07
This file is accessible whenever you use Excel, regardless of which workbook you have open
0:11
allowing you to run your macros across any Excel workbook without needing to copy them each time
0:16
To create a personal macro workbook, go to the Developer tab, then to the Code group
0:21
and click the Record Macro button. Give your macro a descriptive name, set the store macro and dropdown to Personal Macro Workbook, and click OK
0:30
Perform the actions you want to automate, such as clicking the bold, italic, underlined buttons
0:39
and choosing a text color. Stop recording by returning to the Developer tab
0:43
and clicking the Stop Recording button. After recording your first macro, Excel will create a file named personal.xlsb and store it in the ZillStart folder
0:52
To test your macro, write some text in a sheet and run the macro to see the recorded
0:56
formatting applied to the text. Restart Excel to demonstrate that the personal macro workbook
1:01
silently opens in the background. You will be prompted to save both the current workbook
1:06
and the personal macro workbook. Click Save for the personal macro workbook
1:11
After restarting Excel, open a new workbook, write some text, and run the macro. The macro
1:16
will execute and format the text. Open another workbook, select some text, and open the Macro
1:22
dialog box. You'll see the macro is available in this workbook too. Run it to format the selected
1:28
text. Repeat this with any other workbook. The macro in the personal macro workbook is
1:33
available in all workbooks. The personal macro workbook, personal.xlsb, is a hidden workbook
1:40
that opens when you start Excel. If you want to unhide it, go to the View tab and in the Window
1:44
group, click Unhide. In the Unhide dialog box, select personal.xlsb and click OK
1:51
The personal macro workbook's window should now be visible on the desktop
1:55
You can hide the personal macro workbook again by clicking Hide on the View tab in the Window group
2:00
You can also use VBA code in the personal macro workbook by using the Visual Basic Editor
2:05
and any workbook can use or access that code. To access the Visual Basic Editor, press Alt-F11
2:11
You can find the personal macro workbook, personal.xlsb, in the Project Explorer pane
2:17
on the left-hand side. If you want to delete the personal.xlsb file, close the VBA editor and then
2:23
close the Excel application. To open the Zulestart folder, in the File Explorer, type the start path
2:29
as shown on the video in the address bar and press Enter. The Zulestart folder is a special directory
2:34
used by Microsoft Excel to automatically open any files stored within it each time Excel starts
2:39
After deleting the personal.xlsb file, reopen the Excel application. You'll see the macro is
2:45
no longer available. Open the VBA editor and you'll find that personal.xlsb is also not available there
2:52
Thanks for watching! Please like, share, and subscribe for more useful tips and tutorials
