ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stop SetLinkOnData (https://www.excelbanter.com/excel-programming/331400-stop-setlinkondata.html)

Butaambala

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.



All times are GMT +1. The time now is 03:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com