Check filename before running code

[wpryan]

Hi All, I have a service report form which pre-populates certain fields depending on which task is to be done. The task is selected by a drop down box in one of the worksheets. I realized a risk is that if a person selects a task which will pre-populate the fields, completes the form and then for some reason selects a different task that the data will be lost - or alternatively, if the form is completed and saved, and someone else opens it and plays around.... There is a macro built into the workbook that automatically saves the file with a given convention. I want to add some code that looks for the file name, and if it is not the template file name to skip the code which deletes the data. Where I'm stuck is the code that will look for the filename. Can anyone help? Thanks in advance.

 

[WaterGypsy]

I think you need to use:
ThisWorkbook.Name

 

[wpryan]

That was perfect! Thanks!