Having brain cramp, how can I tell if Workbook has changed

[sbendbuckeye]

Hello all,

I have a workbook with some custom menus built into it so I need to emulate the Close dialog regarding saving, yes, no, cancel, etc. But I am having a major brain cramp. How can I determine whether or not the workbook has actually changed.

Thanks in advance for any ideas and/or suggestions!

 

[pgc01]

Hi sbendbuckeye


Please try:

If Not ActiveWorkbook.Saved Then

HTH
PGC

 

[tusharm]

Check the workbook's Saved property.

 

[sbendbuckeye]

Thanks to both of you! I had forgotten that the Saved value is set to True until something changes.