Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop SetLinkOnData
I have successfully implemented the "SetLinkOnData" method to execute a
procedure when a specific link updates. The procedure that is called from SetLinkOnData performs an action if Now() is between certain times, and does nothing otherwise. My question is: Is it possible to turn off SetLinkOnData? i.e. such that the procedure will NOT run with the specific link updates? One thought is to run SetLinkOnData a second time with "" specified as the procedure. However, I wonder will this simply add a second procedure ("") to run when the link updates, or will it turn off the first procedure? I realize that this is unnecessary, since the procedure only runs when Now() is between certain times, but in the interest of minimizing code running in the background, I'd like to make it stop! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop the "started office live" pop-up to stop. it is checked | Excel Discussion (Misc queries) | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions | |||
How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Macro: With Stop it works. Without Stop it doesn't. | Excel Programming | |||
SetLinkOnData help? | Excel Programming |