Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run 2 CreateEventProc modules on 2 sheets simultaneously
Hi,
I have 2 code modules (Workcode1 n Workcode2) which have VBA code for CreateEventProc to enter them into 2 sheets say Sheet1 n Sheet2. i m calling them from a single module called Doit() like this: Sub Doit() Sheets("Sheet1").Activate Call Workcode1 Sheets("Sheet2").Activate Call Workcode2 End Sub giving me Runtime error 9, subscript out of Range. I see that only workcode1 gets added to sheet1 and not workcode2 to sheet2. if i do the vice-versa, i see that it only adds 1 module either workcode1 or workcode2....so i have come to the conclusion that it does not allow 2 CreateEventProc 2 run 1 after the other....it CRASHES EXCEL. How do i go about rectifying this now....Any suggestions r most welcome.. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View sheets simultaneously? | Excel Discussion (Misc queries) | |||
How do I unprotect multiple sheets simultaneously? | Excel Discussion (Misc queries) | |||
How can I protect several sheets in a workbook simultaneously? | Excel Discussion (Misc queries) | |||
How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
Search two sheets simultaneously | Excel Programming |