Track if any changes made after file opened

[sermest]

Hello,

I have a template file which has vb codes, user forms. I want to
activate one of the user forms if no change has made after excel file
opened, or deactivate if any changes made after excel file opened. Is
there any way I can track that?

Thanks,
sermest

 

[OssieMac]

If Not ActiveWorkbook.Saved Then
MsgBox "This workbook contains unsaved changes."
Else
MsgBox "No Unsaved Changes"

End If

Can use ThisWorkbook.Saved. Also the property can be set to True so that you
can exit without saving or getting an Alert message.