will2learn
Board Regular
- Joined
- Dec 1, 2005
- Messages
- 144
I'm having problems with closing Excel down. I've currently setup a number of userform and various macro's.
However when I exit the spreadsheet via a userform and then try to close Excel, I'm finding that Excel just hangs and the hourglass shows. The only way then to close Excel is via ctrl/alt/del and the task manager.
I was using ActiveWorkbook.Close but have had to use Application.Quit which will close Excel down.
However I'm not happy about this and after doing some searching on this site I believe I'm not closing down some of the objects correctly (if at all).
How can I find where I've gone wrong?
Thanks
However when I exit the spreadsheet via a userform and then try to close Excel, I'm finding that Excel just hangs and the hourglass shows. The only way then to close Excel is via ctrl/alt/del and the task manager.
I was using ActiveWorkbook.Close but have had to use Application.Quit which will close Excel down.
However I'm not happy about this and after doing some searching on this site I believe I'm not closing down some of the objects correctly (if at all).
How can I find where I've gone wrong?
Thanks