Macro Checking Code


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.

By: Van

Leave a Reply

Your email address will not be published. Required fields are marked *