LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Saving a workbook within VBA without executing events

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?

---
Patrick Seurre
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem executing a macro from different workbook where it is Sergio Calleja Excel Discussion (Misc queries) 1 January 17th 05 12:38 PM
Events in Excel for executing functions Robin Excel Programming 1 January 9th 04 01:40 PM
executing tasks prior to saving [email protected] Excel Programming 0 September 12th 03 08:36 PM
executing tasks prior to saving Mark Bigelow Excel Programming 0 September 12th 03 06:58 PM
executing tasks prior to saving Tom Ogilvy Excel Programming 0 September 12th 03 06:50 PM


All times are GMT +1. The time now is 07:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"