I work in a warehouse, and currently working with an Excel spreadsheet that has a macro to automatically apply processes to our data.
What I’m trying to do is set it up to prompt a user whether they actually want to save;
IF they are using the Save (not Save As) function, and the original workbook name and current workbook name match.
IF the macro has been run.
We prefer to work from a blank report each time, so saving over the blank with the macro already used, and data in the sheet, gets dicey for us.
I have a basic layout planned, but I’m getting caught up in the actual code to use, as I’m pretty new to VBA.