| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing The Changed State
Hi;
I was wondering if anyone has a code snippet to show me how to set the changed state for a workbook to be changed. I have several routines that create changes to the workbook but when the user X's out it does not ask them if they want to save the changes. Thanks, Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing The Changed State
Hi Greg
normally Excel takes care of this. Do you have any code in the workbook_BeforeSave event? -- Regards Frank Kabel Frankfurt, Germany Gjones wrote: Hi; I was wondering if anyone has a code snippet to show me how to set the changed state for a workbook to be changed. I have several routines that create changes to the workbook but when the user X's out it does not ask them if they want to save the changes. Thanks, Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing The Changed State
In the BeforeClose event for the workbook object you can place th
following Me.saved = true Elsewhere you can put workbooks("NameHere").saved = tru -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace state names with state code abbreviations | Excel Worksheet Functions | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| can worksheet names be changed by changing certain cells? | Excel Worksheet Functions | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| cell data changing when a value within a group is changed | Excel Discussion (Misc queries) | |||
Linear Mode
