AP formulated the question :
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.
Possibly, you need to 'repair' your office installation via
ControlPanelAddRemovePrograms!
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
What is 'admin_change' doing, and why are you using it?
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc