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?)
Add a comment
|
1 Answer
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.