Picking up on Parry's fine post, with the workbook close code, you can specify whether or not you want to save that workbook with a true or a false following on the same line. This example would save the workbook on closing...
ThisWorkbook.Close True
Last edited by Aussiebear; 04-29-2023 at 10:29 PM. Reason: Adjusted the code tags
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote