How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4)

In this video series you will learn how to create a personal macro workbook. I also explain why you should use it.

Read the article and download the Excel file here:

The personal macro workbook is an Excel file that stores all of your personal macros. The file opens in the background every time you open Excel, which means your macros are easily accessible to run any time.

You will learn where the personal macro workbook file is stored on the computer and how to view it. This is great if you need to backup the file or copy it to a new computer.

I also explain how to add macro Buttons to the Excel Ribbon and Quick Access Toolbar. This makes it easy to run your macros on any open workbook.

Finally you will learn how to make a Yes/No message box (pop-up window) to appear before your macro code runs. This is critical if you have macro buttons in the ribbon, as an accidental button press could run a macro that could ruin your workbook.

I also have a free video training series on macros and VBA that will explain everything you need to know to get started. This covers writing your first macro, an explanation of the Excel object model and VBA programming language, how to automate simple Excel tasks, and how to create professional looking userforms.

Other videos in this series:
Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4):

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4):

How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):

Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!
00:00 Introduction
00:49 What is a Personal Macro Workbook
02:13 Enable the Developer Tab
02:49 Record Macro
03:42 Add Sheets

[Risate]

THIS IS SO COOL! You explained what several hours couldn't get through in less than 7 minutes!

[myscene]

Concise and to the point. Hadnt a clue about Macros until I came across your tutorials.
You are a very good teacher. Thank you Jon!

[terrysennette]

I really appreciate the time, knowledge and professionalism that went into creating this tutorial! This is a gem!!!

[maelomusic]

This is spot on explanation on some of my questions. Thank you very much. Please make more videos on Macro - general use tips.

[dfarrey]

Great stuff, as usual Jon in a clear concise training webinar.

[paulang]

You are wonderful, unlike other Youtube show offs, your delivery is clear and concise. Keep up the wonderful work.

[chrismason]

Excel Campus videos are the consistently the best Excel vids anywhere

[rubenmontenegro]

This is good instructions, thank you for taking the time.

[rvelezaulet]

Thanks for your tutorials, easy to understand and helpful.

[nikosgoumenakis]

excellent ...covers all issues, very informative...thanks a lot !

[taniabondar]

Thank you so much, Jon, your videos are the best. all clear and understandable.

[TheHappyCao]

Very good video, many thanks for the training, I will follow with next videos.

[agustinguilmes]

Thank you!!!! You are an amazing teacher!!!

[xNoScOpErZx]

Thank you for this ! Very explanatory.

[kellyboyd]

This was an excellent introduction to macro. Thanks for showing the extra places to see that you're recording as well.

[najeelas]

Sir, It's very useful an thank u

[tomjenkins]

Jon, Thanks for your video's. The Personal Macro is a great place to store my common macro routines. The one thing I have not been able to find an answer to. How can I make the variables in a calling macro visible to the Personal.xlsb macro?

[phillipmaser]

Very Nice Video Series here. Working with Databases that dump or export into excel and other engineering database dump here as well. Combining them into one means less error. Two workbooks saved into one as csv for database interaction. Your information has been a success. I work with a lot of different workbooks that have vendors customers and costs. Now, I am working with PDF's, trying to get data from them into a excel workbook for up load. Any ideas on this? reading pdf charts and a tables. taking data off charts and building linear regression models is next.

[thebravelass]

Thanks for the informative tutorial Jon. What version of Microsoft are you using here?

[kaaa]

Thank you so much for the tutorial. I m trying to download the excel workbook of the "Webinar on VBA Macros for Excel" but I could not find the file. the email that it was send to me it show that " it has expired". would you please, send me the link of the excel workbook and the video.
I loved the video but I can't rewind it. Thanks.