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

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

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

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

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