Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

3 Answers

up vote 2 down vote accepted

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

share|improve this answer
    
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! –  Stuart Maxwell Mar 11 '11 at 16:19
add comment

I had the same problem, but the solution above didn't work.

I found that some Excel add-ins were preventing me from hiding to the personal macro workbook.

After I disabled them, I retried the steps above and everything worked great.

share|improve this answer
add comment

With my upgrade to 2013 Office Pro I started having the same issue when opening an Excel file from the network. I did unhide on the blank instance of Excel and it was the personal workbook. After saving all my VBA scripts as notepad++ files I deleted all the modules.

This did not help either, however, now that I no longer need the personal workbook in VBA I deleted the file from my system. Path C: Users > "User ID Here" > AppData > Roaming > Microsoft > Excel > XLSTART: Personal

Now when I open Excel files from the network, or double click, the app opens only 1 instance.

:-)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.