| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED | Excel Discussion (Misc queries) | |||
| Settings are changed when opening workbook on a different computer | Excel Discussion (Misc queries) | |||
| How can I check if data in an external data range is changed afte. | Excel Worksheet Functions | |||
| Closing an Unsaved (but Changed) Workbook | Excel Programming | |||
| How To: Check if a cell value has changed | Excel Programming | |||
![Jake Marx[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
