| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Track if any changes made after file opened
Hello,
I have a template file which has vb codes, user forms. I want to activate one of the user forms if no change has made after excel file opened, or deactivate if any changes made after excel file opened. Is there any way I can track that? Thanks, sermest |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Track if any changes made after file opened
If Not ActiveWorkbook.Saved Then MsgBox "This workbook contains unsaved changes." Else MsgBox "No Unsaved Changes" End If Can use ThisWorkbook.Saved. Also the property can be set to True so that you can exit without saving or getting an Alert message. -- Regards, OssieMac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep the track of persons how opened the sheet and made changes. | Excel Programming | |||
| can't find file opened from email,changes made & saved | Excel Discussion (Misc queries) | |||
| Track when a file has been opened | Excel Discussion (Misc queries) | |||
| Track whose made changes | Excel Programming | |||
| Can I track changes made to a shared file per userid. | Excel Discussion (Misc queries) | |||
Hybrid Mode
