Open the VBE(ALT+F11). You should see the Project Explorer on the left!! If not, enter CTRL+R to open it. DoubleClick on the module "ThisWorkBook" and paste the code I posted in the white panel. Change the SheetNanme and cell reference for your desired "Check Off" cell!I t's really quite easy. The code will run whenever you save the file. You may want to go with a sightly different code
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If Sheet1.Range("$A$1") = "" Then
MsgBox "Approval required"
Cancel = True
It might be less confusing for making backup saves