Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet ("MySheet") with about 300 lines of code in the
Worksheet_Change event. When a user opens the workbook, MySheet will be copied as many times as the user indicates (maybe up to 30-40 times). As a result, my 300 lines of code goes up to about 12,000 lines. I am wondering if it is possible to put the code into a separate module, and then use the Worksheet_Change event to call the code from that other module. ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Worksheet_Change | Excel Discussion (Misc queries) | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Getting around Worksheet_Change() | Excel Worksheet Functions | |||
Worksheet_change won't run | Excel Discussion (Misc queries) |