Save/close EXCEL workbooks.
Given several excel WB and made some changes in personal.xlsb. If I want to exit EXCEL, the options should be:
1. If I click “X” on the toolbar in displayed WB, then options are:
a) Save/close opened WB
b) If there more opened WB’s then there is one more option “Save/Close all opened WB”
c) After saving all opened WB’S automatically comes up option save/close “PERSONAL”.
- On the taskbar If I click EXCEL’S icon right, and several WB’s are opened then there is option
“Close All Windows” which one doesn’t function properly. Please make this command to do literally command “Close all windows” exactly as the same command works for WORD documents or OUTLOOK applications.
- Keyboard shortcut: SHIFT ^ Click “X” could work for closing one by one, if we have several WB opened.
- We need a command “EXIT EXCEL” which close all WB’s, DOCX’s and Outlook applications and exits EXCEL.
If there are multiple documents open and minimized, any with unsaved changes, and I right-click the taskbar and choose "Close all windows" then it just flashes at me, leaving all windows minimized. It should at least bring a document with unsaved changes to the foreground, to prompt if I want to Save or Cancel, like it does when there is only one document open.
For reference, I ensured my taskbar combining behavior for multiple instances is correct as per this article: https://contexturesblog.com/archives/2018/11/08/how-to-close-all-excel-files/
P.S. It would be even better if simply opening an Excel document wouldn't automatically create unsaved changes in certain cases (e.g. an onload VBA macro, or a spreadsheet created thru an interop with automatic sheet updates disabled so it refreshes on open).