Why does personal.xlsb open

Every time I open Excel, the Personal. It did not used to do that. Anyone know how I can prevent it from opening?

After that, close Excel, and you will face a message asking you to save the changes you made to the Personal Macro Workbook, click Save. I am suffering the same thing. Since Excel opens a new instance each time, and not just a new book, it's also opening the personal macro workbook, saying it's already in use and if I want to open it as read only or be notified when it is available. Products 75 Special Topics 42 Video Hub Most Active Hubs Microsoft Teams.

Security, Compliance and Identity. Microsoft Edge Insider. Personal Macro Workbook is a special file named Personal. Any macros stored in this file are available to you whenever you start Excel. A great thing about the personal workbook is that it's hidden by default, so you won't ever notice it opening in the backend. No actions on your side are required. Microsoft Excel just knows the location where this file lives in your system and looks for it automatically on every launch.

A fly in the ointment is that the Excel Personal Macro Workbook does not exist by default. To create it, you will need to record at least one macro. Once the Personal. Please note that the AppData folder is hidden by default. To make your personal macro workbook, you need to record any macro, which is done via the Developer tab.

So, before we get started, please make sure the Developer tab is activated in your Excel. This message will appear every time you create a new macro or update an existing macro in your personal workbook. The Personal. Now that you have a personal macro workbook, how do you place macros into it? There are four different ways to do this:. Also, you can copy the code you wish to reuse from another workbook.

Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. How do i stop it. Thread starter cwilliams96 Start date Mar 12, Joined Jul 27, Messages I recorded a few macros.

Each time i open a spreadsheet, even if it doesnt contain macros, the workbook opens, but so does a personal workbook. Then things would fail when they tried to use it, a situation I try to avoid as much as possible.

Table of Content Close. XLSB Workbook. MAC Version. A Export and Import the Module. B Copy-Paste Personal. Delete Personal Macro Workbook. Hide it if Excel Keep Opening it Every time. Lock Personal. In the End,. More on VBA. Thank you very much, really helpful Reply.