How to escape the Workbook Save?
 

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

How to escape the Workbook Save?
 

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?

Thanks a lot

Jie
.

How to escape the Workbook Save?
 

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

Jie

How to escape the Workbook Save?
 

try disabling events in the application object