• Formulas
  • Excel Tips & Tricks
  • Excel Charting
  • Tutorials
  • VBA
  • Book Store
  • More
    • Blog
    • Download Area
    • Excel Video Tutorials
Home » Macro Mondays -Creating and Updating Your Personal Macro Workbook

Macro Mondays -Creating and Updating Your Personal Macro Workbook

November 19, 2018 by Barbara

Hello Excellers, welcome to another #macromonday blog in this series. Today let’s look at saving macros to a personal macro workbook to reuse in any workbook when you start Excel on your computer.

Create Your Personal Macro Workbook

When you create a macro in Excel it is usually designed to work in just one particular workbook, but there may be some instances where you want to use some Excel macros which are much more general, that you can use in all or at least make them available to use all of your workbooks.

There is place in Excel where you can store these macros and call on them at any time, this is the Personal Macro Workbook. This special workbook is loaded up whenever you start Excel, but it does not exist in until you actually record a macro in Excel and save it in this location. That’s really easy to do with a few steps you can follow below.

  • Ensure the Developer Tab is enabled in Excel. If you cannot see it then you can easily enable it. If you need instructions on how to do this then you can read my blog post here.
  • Now you can record a Macro to save in the Personal Macro Workbook. (Let’s just make some text bold in our workbook).

An Example Macro

  • In cell B2 type some text – in this example, I have typed Hello World.
  • Select the Developer Tab – Code Group – Record Macro.
  • In the Macro Dialog Box, give the Macro a name- in this example, I have used mytestmacro.
  • In the Store Macro in: select Personal Macro Workbook.

personal macro workbook

 

 

  • Hit Ok.
  • Hit CTRL+B to make your text bold (this is all we want to do for this small macro).
  • On the Developer Tab – Code Grouping – Stop Recording.
  • Close any workbooks and exit Excel.
  • When prompted, save the changes to your Personal Macro Workbook.
  • Select to save the workbook.

personal macro workbook2

 

The next time you start Excel, your Personal Macro Workbook will load, but it is hidden by default, but you can easily view it –

  • View Tab
  • Window Group
  • Unhide
  • You should now see PERSONAL.xlsb

Any macros you save to your Personal Macro Workbook will be editable but only when you chose to unhide it. It is also easy to hide the Personal Macro workbook as well.

  • View Tab
  • Window Group
  • Hide

If you create any new macros and save them in your Personal Macro Workbook, or edit any macros that it contains you will again be prompted to save the workbook, just as you did the first time it was saved.

 

What Next? Want More Tips?

So, if you want more tips then sign up for my Monthly Newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.

1If you want to see all of the blog posts in the Macro Monday series. Click on the link below

Macro Mondays Blog Posts.

 

Learn Excel With Our Excel Online Courses

Do You Need Help With An Excel Problem?.

Finally, I am pleased to announce I have teamed up with Excel Rescue, where you can get help FAST. All you need to do is choose the Excel task that most closely describes what you need to be done. Above all, there is a money back guarantee and similarly Security and Non-Disclosure Agreements. Try It!. Need Help With An Excel VBA Macro?. Of course, you don’t need to ask how to list all files in a directory as it is right here for free.

 

ExcelRescue.net

Udemy.com Home page 125x125

Filed Under: Blog, Macro Mondays, Macros Tagged With: Excel Tip Category, Macros, VBA

Tags

Blog Cells Excel Excel Charting Excel Excel Tips Excel Formulas excel tip Excel Tip Category Excel Tips Excel Tips& Tricks excel tutorials Excel Videos Excel Video Tutorials formatting Formula formula friday Formulas macro Macro Mondays Macros Pivot Table Pivot Tables Power BI Power Query Tutorials vb VBA Worksheets

Recommended Excel Resources

Free Excel Dashboard Webinar

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in

Share
Tweet
Additional Info

Want FREE Excel Tips?

Click on my FREE eBook, its my bonus for joining thousands of others who receive my 3 xFREE Excel tips every month in my Excel Newsletter. Join Us!.

Need Answers To Excel Questions Like These?

*How Do I Create A Timestamp In Excel?
*I Want To Change The Width Of The bars On My Excel Chart
*How Can I Find Out The Length Of My Text in Excel? Click the link below to receive more Excel tips' and my Free Ebook

New To Excel? This Is A Great Place To Start!!

Learn Excel Dashboard Course Excel Basics
Scrollbars
Colour of Sheet Tabs
Conditional Formatting
Calculations Introduction

Excel Charting

Self Expanding Charts
One Click Charts
Create Quick Dynamic Charts
Easy Combination Charts

Video Tutorials-If You Like To Learn By Watching

Subscribe to YouTube to get notified of of new Excel videos.


Self Expanding Chart
Delete Obsolete Items From A Pivot Table-Excel 2007
What Are Pivot Tables- Create Your First One
Enable The DeveloperTab In Excel

Some Fun Stuff

Pivot Table Song



  • Privacy Policy