Macro Checking Code

Hello,

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.

AND

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 *