Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Event procedures: who is calling? | Excel Programming | |||
many similar event procedures | Excel Programming | |||
Event Procedures in an Add-In | Excel Programming | |||
learning event procedures | Excel Programming | |||
Change to excel settings launching an event | Excel Programming |