Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent save when content change?
Hi,
I wuould like to know if any method can disable "save when change" function in excel using vba. Since I do not want the pop-up when closing the excel. Thanks. Nick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent save when content change?
Application.DisplayAlert = False
' your save commands here Application.DisplayAlert = True Cheers Nigel "Nick" wrote in message ... Hi, I wuould like to know if any method can disable "save when change" function in excel using vba. Since I do not want the pop-up when closing the excel. Thanks. Nick |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent save when content change?
Hi
one way: put the following in the workbook_beforeclose event: activeworkbook.saved = true -- Regards Frank Kabel Frankfurt, Germany Nick wrote: Hi, I wuould like to know if any method can disable "save when change" function in excel using vba. Since I do not want the pop-up when closing the excel. Thanks. Nick |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent save when content change?
the point is i really don't user to save the file, any method?
thanks Frank Kabel wrote: Hi one way: put the following in the workbook_beforeclose event: activeworkbook.saved = true |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent save when content change?
Hi
then put the following in the workbook_beforesave event: Cancel=true BUT: all the user has to do to prevent this is disable macros. Why not save the file as read-only (with password) -- Regards Frank Kabel Frankfurt, Germany Nick wrote: the point is i really don't user to save the file, any method? thanks Frank Kabel wrote: Hi one way: put the following in the workbook_beforeclose event: activeworkbook.saved = true |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I restore previous content before a save? | Excel Discussion (Misc queries) | |||
Prevent color change open/save sheet? | Excel Discussion (Misc queries) | |||
Prevent from save if... | Excel Discussion (Misc queries) | |||
Save as using cell content in file name | Excel Programming | |||
Help! MsgBox and Prevent Save | Excel Programming |