Check if workbook has been changed
 

Hi Yong,

Yong wrote:
How to check if the opened workbook has been changed since last
opened programmatically?

The Saved property of the Workbook object will tell you whether it is
"dirty" or not.

If wb.Saved Then
'/ no changes since last save
Else
'/ changes have been made
End If

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]