How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Question

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening?

I have since deleted the macros, but I still get the workbook popping up every time I open the program. It's an annoyance, more than anything, but one I'd like to eliminate.

Solution 1

On Excel 2010 for Windows you can hide a given workbook (View tab, Hide) and it stays hidden when you restart Excel. Try that.

Solution 2

While viewing the Personal workbook, go to Mac's Excel 2011 "Window" in the menu bar and it should show that Personal is checked. If not, check it. Then use Hide in that same menu. This works through a restart.

Gleaned from source: https://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/excel-for-mac-personal-macro-workbook-locked-for/e9727ba3-7e9f-41dd-875b-6c304388968c

DO NOT DELETE the Personal workbook. It contains your macros and all kinds of stuff. Deleting it will cause Excel to make a new one but your macros won't be there. Yes it will make Excel not show it, but only because the default for Personal is to not show it.

I also see that the OP Stuart posted this earlier, but it was a short sub-entry so I didn't see it until after posting this. I would have deleted my post but I thought the reason for not removing the Personal workbook should be noted.

Solution 3

Delete the file from my system. Path C: Users > "User ID Here" > AppData > Roaming > Microsoft > Excel > XLSTART: Personal.

And use "This workbook" as macro store in option.

Solution 4

The solution regarding deleting the macro workbook worked for me, but the instructions need to be adapted for the Mac (the poster is referring to Windows, but the OP asked about Excel 2011, which is a product for the Mac).

The file path containing the personal macros workbook on the Mac is:

/Users/[your user name]/Library/Application Support/Microsoft/Office/Excel

Removing the personal macros workbook from here solved the problem of Excel showing the personal macros workbook every time that Excel 2011 starts.

View more solutions

Comments

[Umair Rana]

Woo-hoo! You're brilliant, Paul. I opened Excel and went to the Window menu and selected Hide. Then I quit Excel and saved the changes to the Personal Macro Workbook. When I next opened Excel, the template chooser popped up instead of the PMW. Thanks for the suggestion!