| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsDirty
How would I know that there are unsaved changes in a workbook?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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] |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
