Hi,

I'm developing a counter/timer spreadsheet.

Initially the spreadsheet uses an rtd which pulls information from elsewhere to detect if the counter on/off conditions are met in combination with an application.ontime sub, however the refresh rate is too slow. The triggering event can be less than a second, so the code I've written can't detect the triggering action and sometimes, the rtd doesn't refresh in time to detect.

One possible way to detect this trigger is based on an Active X button on another spreadsheet. Pressing once starts/stops an action.

I can't modify the triggering spreadsheet as it's a secured controlled document, so if I could write a script on another excel spreadsheet to detect either the triggering of sub/clicking of the button that would be great.

How would I start off on this?

Thanks!

Joel.