Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you reset 'change was made in workbook' switch?
I've written VBA code in the Workbook_Open() event that
initializes some controls in a spreadsheet to default values. Once this is done, I'd like to reset the switch that gets set when a change is made to a worksheet so the user won't be asked if they want to save the document unless the user actually makes a change in the worksheet after the default values are set. How do you reset the switch that indicates that a change was made in the workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you reset 'change was made in workbook' switch?
ThisWorkbook.Saved = true
tim "Vince" wrote in message ... I've written VBA code in the Workbook_Open() event that initializes some controls in a spreadsheet to default values. Once this is done, I'd like to reset the switch that gets set when a change is made to a worksheet so the user won't be asked if they want to save the document unless the user actually makes a change in the worksheet after the default values are set. How do you reset the switch that indicates that a change was made in the workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only save and print if change made | Excel Discussion (Misc queries) | |||
Is there a shortcut key to switch from one workbook to another? | Excel Discussion (Misc queries) | |||
Changes made and saved are not there after workbook is closed | Excel Discussion (Misc queries) | |||
i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) | |||
how do i switch between multiple sheets in the same workbook (key. | Excel Discussion (Misc queries) |