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

Excel Campus - Jon
Excel Campus - Jon
233.3 هزار بار بازدید - 8 سال پیش - Sign up for our Excel
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

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:
http://www.excelcampus.com/vba/person...

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):
Where Is The Personal Macro Workbook ...

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

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

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
8 سال پیش در تاریخ 1394/12/27 منتشر شده است.
233,310 بـار بازدید شده
... بیشتر