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

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
.

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

Jie

try disabling events in the application object