If you do not want the “Save as” dialog box to appear and handle saving yourself through VBA, you can tick “Allow save but do not handle loading/saving”. Otherwise, leave this option unchecked if you don’t want modifications to be lost when Excel closes.

VBA developers can also use VBA code extension to automatically save secure workbooks without user prompt. See 11.3 Saving a secure copy of the workbook without prompt.