| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you turn off "Do you want to save changes you made to ..."
How can you turn off "Do you want to save changes you made to 'filename'.xls"
when closing a file, in Excel 2003, if you made no changes. Excel used to recognize that no changes were made. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you turn off "Do you want to save changes you made to ..."
Hi,
To generate this prompt something is changing in the workbook even if you don't recognise it as being a deliberate change but you could do this. Alt +F11 to open VB editor. Double click 'This Workbook' and paste this in on the right Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Saved = True End Sub But be aware you won't get the prompt to save if you have made changes you want to keep and could end up losing them. My view FWIW, I wouldn't do it but perhaps that's just my instinct to protect data. Mike "Cereal Killer" wrote: How can you turn off "Do you want to save changes you made to 'filename'.xls" when closing a file, in Excel 2003, if you made no changes. Excel used to recognize that no changes were made. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you turn off "Do you want to save changes you made to
Might be something like
=TODAY() -- Gary''s Student - gsnu200781 "Mike H" wrote: Hi, To generate this prompt something is changing in the workbook even if you don't recognise it as being a deliberate change but you could do this. Alt +F11 to open VB editor. Double click 'This Workbook' and paste this in on the right Private Sub Workbook_BeforeClose(Cancel As Boolean) Me.Saved = True End Sub But be aware you won't get the prompt to save if you have made changes you want to keep and could end up losing them. My view FWIW, I wouldn't do it but perhaps that's just my instinct to protect data. Mike "Cereal Killer" wrote: How can you turn off "Do you want to save changes you made to 'filename'.xls" when closing a file, in Excel 2003, if you made no changes. Excel used to recognize that no changes were made. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| remove the default,"Do you want to save changes made to xxx.xls?" | Excel Discussion (Misc queries) | |||
| How do I turn off the "do you want to save" alert in excel? | Excel Discussion (Misc queries) | |||
| How do you turn off "Save a copy/Overwrite changes" dialog box | Excel Discussion (Misc queries) | |||
Linear Mode
