IsDirty
 

How would I know that there are unsaved changes in a workbook?

IsDirty
 

Hi AMDRIT,

AMDRIT wrote:
How would I know that there are unsaved changes in a workbook?

The Saved property of the Workbook object will tell you whether it's "dirty"
or not:

If ActiveWorkbook.Saved Then
'/ no changes have been made
Else
'/ workbook is dirty
End If

--
Regards,

Jake Marx
www.longhead.com


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

IsDirty
 

Thanks a lot, I missed that property when looking in the intellisense.


"Jake Marx" wrote in message
...
Hi AMDRIT,

AMDRIT wrote:
How would I know that there are unsaved changes in a workbook?

The Saved property of the Workbook object will tell you whether it's
"dirty" or not:

If ActiveWorkbook.Saved Then
'/ no changes have been made
Else
'/ workbook is dirty
End If

--
Regards,

Jake Marx
www.longhead.com


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