Comments on: Personal Macro Workbook in Excel - make macros available in all workbooks

Normally, when you create a macro in Excel, it can only be accessed from that specific workbook. But what if you want to use it in other files too? Store your popular VBA codes in the Personal Macro Workbook. Continue reading →

Table of contents

Comments page 2. Total comments: 25

  1. Tried creating a macro and save it to a Personal Macro Workbook, but got an error message that said,
    "Personal Macro Workbook in the startup folder must stay open for recording." I have no idea what this means. I see nothing about it in the startup folder. When I clicked OK, I was further informed that the macro would not record. Please help.

    1. Hey Paul -
      Search for the PERSONAL.XLSB file and open it. Once open, click: View > Hide.

      On the workbook you are trying to create a macro in, click "Record Macro" again, should work!

  2. Thank you Ms. Svetlana for writing this blog. It was *exactly* what I needed and more. I found your post through a Bing search, but will be exploring your website and products later. Thanks again and God bless. --Jeff Fuhr

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)