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.

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?)

share|improve this question

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

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