How to escape the Workbook Save?

[Jie]

H

It seems Excel saves the workbook every time when the Save button is clicked as the workbook date time has been changed. Is it possible to escape the save if Workbook.Saved = true inside ExcelApp.WorkbookBeforeSave() event handler

Thanks a lo

Jie

 

[Frank Kabel]

Hi
within this event procedure add the line
Cancel=True

-----Original Message-----
Hi

It seems Excel saves the workbook every time when the

Save button is clicked as the workbook date time has been
changed. Is it possible to escape the save if
Workbook.Saved = true inside ExcelApp.WorkbookBeforeSave()
event handler?

 

[Jie]

I tried this and it still saves the workbook as the modified date of the workbook file indicates

Jie

 

[Karthik Palaniappan]

try disabling events in the application object