VBA code to check if any changes have occured

[kgkev]

As part of my current VBA script I give the user the option to save the workbook.

however if the work book as just been opened and no changes have taken place then I don't want to give the user the option.


My idea... If you open a workbook and close it Excel does not prompt you to save, it simply closes. If you make any change you get the do you want to save prompt.

It is possible to identify the variable that controls this and use it for my purpose?

 

[Gary McMaster]

The following is from VBA help for XL2010 & XL2013. Not sure if it will work on older versions.

The "Saved" property returns True, False or "" ("" = never been saved)

If Not ActiveWorkbook.Saved Then
 
 MsgBox "This workbook contains unsaved changes."
 
End If

 

[kgkev]

Perfect - Thanks.