Since you never save your workbook normally, on the rare instance you DO want to save a partially completed survey then that saved workbook will now have a different name than your main workbook. So your Workbook_Open macro need only check the name of ThisWorkbook. If the name is the normal name, clear all data and proceed clean, but if the name is anything else, do not clear the data.