Personal Macro Workbook is locked in "read only" mode

[cpFAL96]

My personal macro workbook is locked in read only mode. It's creating issues when I try to open macro-enabled files. I can still view my modules when I open a non-macro workbook but it won't allow me to save the file.

Can someone help?

Thanks!!

[Keebellah]

If your Personal macrobook is pocked it probebly means that there is another instance of Excel using it too.
What happens if you close all workbooks and jus open Excel?
Can you edit the vba project contents of the Personal macrobook and save it ?

BTW is it Windows or MAC?

[Zahid0111]

If your personal macro workbook is locked in read-only mode, you will not be able to edit or save the macros in the workbook.

There are a few potential reasons why your personal macro workbook might be locked in read-only mode:

The file may be stored on a network drive or shared folder that has read-only permissions. In this case, you will need to contact the administrator or owner of the drive or folder to request write permissions.

The file may be set to read-only by the system or by the user. To check if the file is set to read-only, right-click on the file and select "Properties". If the "Read-only" checkbox is checked, uncheck it and click "OK".

The file may be protected by a password. If the file is protected by a password, you will need to enter the password to edit or save the macros.

If none of these solutions resolve the issue, it is possible that the file is corrupt or damaged. In this case, you may need to create a new personal macro workbook and re-import your macros into it.

To create a new personal macro workbook, follow these steps:

Go to the "View" tab and click the "Macros" button.
In the "Macros" dialog box, click the "Create" button.
In the "Create New Macro" dialog box, enter a name for the macro and click "Create".
A new personal macro workbook will be created and opened in a new window. You can then copy and paste your macros from the old personal macro workbook into the new one.
I hope this helps.

[cpFAL96]

If your Personal macrobook is pocked it probebly means that there is another instance of Excel using it too.
What happens if you close all workbooks and jus open Excel?
Can you edit the vba project contents of the Personal macrobook and save it ?

BTW is it Windows or MAC?

All other files were closed and the computer was restarted multiple times. It's a Windows computer. Also no one else would be using these files except for me.

If I open a normal workbook that doesn't have macros enabled, I can see the code and edit but not save it.

[Keebellah]

Close everything and check the excel startup folder and see what rights you have in your profile
I suggest you look up how to take ownership of your own profile and subfolders

[cpFAL96]

I worked with our office IT/Excel expert (who was not available yesterday) and after trying a whole bunch of things we ended up having to re-install Excel. I was thinking it was specific to VBA but it was an Excel glitch. All resolved now, thanks everyone!

[Keebellah]

Good to hear now you can go into 2023 with Excel-lent perspectives