Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deactivate save changes
Excel 2003
I execute code in Before Close workbook in This Workbook My problem is that excel re-asks if the user wishes to save changes after doing the code. Is there a way to deactivate the save changes dialog? Many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deactivate save changes
Add:
ThisWorkbook.Saved=True at the end of your code. (assuming you don't want them to save it...) Tim "Roger on Excel" wrote in message ... Excel 2003 I execute code in Before Close workbook in This Workbook My problem is that excel re-asks if the user wishes to save changes after doing the code. Is there a way to deactivate the save changes dialog? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deactivate Code | Excel Programming | |||
Deactivate Save As | Excel Discussion (Misc queries) | |||
Worksheet Deactivate | Excel Programming | |||
Deactivate autofill | Excel Programming | |||
Deactivate Formula | Excel Programming |