How to Create a Personal Macro Workbook in Excel.

I have a lot of other videos where I want you to put a few lines of VBA into your Personal Macro Workbook. I am always thinking that many people won’t have a Personal Macro Workbook. My goal with this video is that any time a future video mentions the Personal Macro Workbook, I can ask you to watch this video to create a Personal Macro Workbook and then you can go back to the other video for the VBA code for that particular task.

Table of Contents
(0:00) Excel Create a Personal Macro Workbook
(0:18) Do you already have Personal.xlsb?
(0:41) Recording Hello macro into Personal Macro Workbook
(1:42) Need to Save Personal.XLSB so do it now
(2:12) Add Developer tab to Ribbon
(2:10) Open Visual Basic Editor
(2:38) Open Project Explorer in VBA
(2:55) Saving Personal from VBA Editor
(3:22) Wrap up with Wally & Nancy