How to escape the Workbook Save?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...
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?
 
I tried this and it still saves the workbook as the modified date of the workbook file indicates

Jie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create new workbook and new worksheet and close. Worksheet not saved 1
"Save" macro problem, still prompted to save when closing workbook (?) 8
Problems with Workbook Before Save Event 7
All Workbook Saved except This Workbook 3
All Workbook Saved except This Workbook - Part2 3
button for saving all workbooks 6
Addin not allowing thisworkbook.save in before save event 3
COM addin won't connect when workbook opened via another workbookfrom another instance 3

Back
Top