VBA projects!! Aaaargh!
I had this problem and discovered it was because the Excel process was still running even after closing Excel.
I think this was somehow related to testing I'd been doing in VBA which had caused errors.
Anyway, it was easy enough to fix: Close Excel. Open the Task Manager in Windows, and End all the Excel processes still running.
Then when you fire it up again, the problem will be solved and closing a file will unload the projects.
|