I have a workbook that has several VBA userforms that are used for data entry that interact with workbook. The Worksheet_open sub shows a modeless form (master menu) with a number of command buttons that actually load other forms and do all calculations when selected. One of these command buttons is a close button for the menu. It unloads the form. Nothing is queued up at that time. If I save the workbook all is well and then I can close Excel without a problem. If however, I selected Do Not Save when prompted, I get an out of memory error. This pops up three times before Excel closes. Sometimes it saves a recovery file and sometimes it saves and restarts. When I open and select the file to recover and say repair, it says there is nothing to repair. This behavior occurs even if I do none of the commands, that is when the menu appears, I tell it to close and then immediately close the workbook and Excel without saving. I believe I have ample virtual memory.
Bookmarks