

Then possibilities are high that the directory in which this Personal Workbook is kept, Excel counting it as untrusted one.īy default, the Workbook is got created in the directory similar to the following.Ĭ:\Users\Allen\AppData\Roaming\Microsoft\Excel\XLSTART If you are facing this Personal.xls File Not Opening in your personal.xlsb file. In this section, we will talk about several aspects of Personal Macro Workbook Not Opening Issues and of course ways to fix it. How To Fix Personal Macro Workbook Not Opening Issues?

So, for fetching this XLSTART folder in Windows Explorer.

It’s a time savior option, as you don’t need to create the same macro again and again for all your workbook. After this, your macros become easily accessible from any workbook. But if you need to use the same macro in other Excel files storing these macro VBA codes in Personal Macro Workbook is the best option. Generally, when you create or record any macro in Excel, you can only access or use it from that specific Excel workbook. Why Should I have a Personal Macro Workbook?
