View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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
.