| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop UDF firing when sheets(n).calculate
Greetings and TIA for your time
I have a UDF which is called by cells only on sheets(2) and is neither a president or dependent of anything in sheets(1) During running code I have sheets(1).calculate in each pass of a loop. For some reason this fires the UDF. It fires once for each instance on sheets(2) This slows the code down considerably How can I stop the UDF firing? -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STOP Auto Calculate | Excel Discussion (Misc queries) | |||
| Calculate how much time falls between set start and stop times | Excel Worksheet Functions | |||
| Excel 2002: Formulas stop calculate correctly after 13.4MB | Excel Discussion (Misc queries) | |||
| Stop Worksheet_SelectionChange event from firing? | Excel Programming | |||
| class events stop firing with ADO 2.8 | Excel Programming | |||
Threaded Mode
