Saving a workbook within VBA without executing events

P

Patrick Seurre

I'm trying to use one workbook to customise a second pre-existing workbook
and then save the second workbook and close it. This second workbook though
has code associated with it's events that appear to be executed when the
..Save method is called. I've tried setting the Application.EnableEvents
property to false in the code of the first workbook and immediately before
the call to the .Save method, but each time this is called it appears to be
re-enabled when the .Save method is called (I've verified this by adding
watches and stepping through the code).

Does anybody have any idea as to why this might be happening and what I can
do to stop it?
 

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

Top