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: 10
Default Conflicting event procedures launching at the same time

I have code in sheet 1 that on deactivation looks for an error on
sheet 1 and if it finds one goes to the cell with the error.

At the same time in the code for ThisWorkbook, I've got code that
before saving stores the current cell location then goes to sheet 3
and does some copying and pasting and then goes back to the starting
cell.

I deliberately put an error in Sheet 1 and then hit the save button.
That launched the "before save" code that goes to sheet 3. That in
turn launched the deactivation code on Sheet 1. Each code is set to
go to different sheets and do stuff. They ended up running
simultaneously and doing something I didn't want them to.

Each code by itself works fine, it's just under certain circumstances
that they run at the same time.

I've been using these event procedures for all of two days. Is there
a way to make them run in a certain order?

Thanks so much in advance.
 
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
Event procedures: who is calling? Momo[_2_] Excel Programming 2 April 22nd 06 08:12 AM
many similar event procedures natanz[_2_] Excel Programming 1 November 4th 05 02:26 PM
Event Procedures in an Add-In DJB[_10_] Excel Programming 3 September 17th 05 08:11 AM
learning event procedures R.VENKATARAMAN Excel Programming 4 January 21st 05 01:09 PM
Change to excel settings launching an event Jeff Standen Excel Programming 2 August 12th 04 02:00 PM


All times are GMT +1. The time now is 08:37 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"