Personal Macro Workbook Locked for Editing

Hi everyone,

My Excel 2011 for Mac gives me a popup every time I open it:

LockedforEditing.png

When I click "Read-Only," this pops up:

EditPMW.png

I usually just click "Read-Only" and "Cancel" to start working, but it presents two problems:

1. It's annoying; and
2. It prevents me from saving any macros in my Personal Macro Workbook.

Recently, when I've tried to save a macro to my personal workbook, it's started telling me this:

PMWStartup.png

Then that it's "Unable to Record."

I tried to follow the path in my HD to the Office/Excel folder to find the Personal Macro Workbook -- and I don't think it exists anywhere, which might be the problem, but I'm not sure and I don't know how to fix it if it is.

Any suggestions?

It must exist or you wouldn't get those messages. Perhaps it is disabled or has been marked as read-only somehow.

Any idea what I should do to get rid of the messages and start being able to save to my Personal Macro Workbook again?

You may simply need to change the file permissions on the folder in which it is located.

I think the potential problem is that I can't find the folder where it's located. If you look at the 'EditPMW' image, it tells me the path of where it's supposed to be -- but when I get to Microsoft/Office folders there's no 'Excel' folder for me to click on.

I seem to recall that the USERS\user_name\library folder is hidden by default - can you actually see that folder?

It seems to work when I search for 'Library' in Finder, and when I look at the path when I click on that folder, it says, "HD\Users\Shared\Username\Library, then I can get to 'Application Support\Microsoft\Office' -- but within the 'Office' folder, there should be an 'Excel' folder, but all I have is Chart Templates, Clipart, SmartArt Graphics, and User Templates.

Open a Finder window, hold the Option key down and click the Go menu item and choose Library. From there navigate to Application Support\Microsoft\Office\Excel and see if the workbook is there. If it is, use the Get Info option to check what rights you have to it (in the Security section) - you need Read/Write.

One step closer! Thanks! I apparently wasn't looking at the correct path earlier, as now I have the Excel folder within 'Office' and I can see my Personal Macro Workbook.

Only problem is that it looks right? My privilege is "Read & Write," "Fetching..." is Read only and "everyone" is Read only.

Any ideas?

When you view the workbook in Finder and use Get Info, did you check the permissions on both the workbook and the Excel folder? Can you also check that neither has the Locked option checked?

Both the Excel folder and the Personal Macro Workbook have the same settings: neither are locked and they're both "Read & Write" for my permissions.

Is this a new problem? Did you create the Personal Macro Workbook on that machine?

It didn't happen when I first got Office 2011 -- then I remember it happened maybe a little over a year ago, and I think I fixed it somehow. After that, something happened fairly recently (within a few months) and it came back. When I 'fixed it' the first time, I don't believe I created anything. Pretty sure I just went in and deleted the macro that was causing problems -- but it won't let me do that this time because it's read-only.

Can you remove the workbook (move it to another folder) and then restart Excel and make sure all is OK. Then restart Excel and record a new macro, then exit and save the new macro workbook and see if that all works without error.

That is as it should be. This still sounds like a permissions issue to me - you may want to try repairing disk permissions.

A little stumped -- but I know a lot more about it than I used to. Thanks for all the help!