Workbook_BeforeSave
On Jul 19, 1:59*am, GS wrote:
Could this possibly be a permissions issue?
The strange thing is that manual saving works (File Save) but any
code (except MsgBox) associated with the save event are ignored. And
no amount of pausing or DoEvents remedies it.
Even the "SaveChanges" part of the following gets ignored:
ActiveWorkbook.Close SaveChanges:=False
I have to get around this with:
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
|