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
|