Home » Questions » Computers [ Ask a new question ]

How do I prevent Excel 2007 from opening hidden workbooks, so the X button exits Excel completely?

How do I prevent Excel 2007 from opening hidden workbooks, so the X button exits Excel completely?

"I've been frustrated recently because Excel 2007 no longer exits when I click the upper-right X button. Instead, it simply closes the current workbook. I've found a partial answer here: the behavior is due to the ""personal macro workbook"" being open and hidden. Deleting the macros from it and deleting the workbook itself would solve the issue.
Is there a way to solve this without deleting my macros? (Can I get Excel to stop opening this hidden workbook automatically each time it starts?)"

Asked by: Guest | Views: 285
Total answers/comments: 1
bert [Entry]

"Move the File PERSONAL.xslb to another directory. Any file in the directory XLSTART is opened on stat up.
Then just open your personal macro file when needed."