ActiveX Plug In Not Available in a Module

[matt.adams]

I am using Excel 2007 in a pretty atypical way. I have an ActiveX plugin that allows me to communicate with an industrial device. It allows me to query the device and receive an array of data back. This is working well.

My application is pretty simple: I send a couple of values to this device to start it, and then sometime later (like an few hours) I send another value to abort / stop it.

I'm using a pretty simple call to do this:

RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
Application.OnTime EarliestTime:=RunWhen, Procedure:="Abort", Schedule:=True

I need to have the Abort procedure in a Module (Module1) or I get an error saying that I don't have permission to run the macro. (Very frustrating!)

My problem is that though the Abort sub will execute when located in Module1, the ActiveX plugin I've added to Sheet1 doesn't work in Module1, and I can't seem to figure out a way to add it or register it in the module.

So, I need either a way to have the procedure called to be sub routine within the sheet (which would be best!) or added this ActiveX plugin to the module so that I can use its functionality.

Any ideas or help?

Thanks in advance,

Matt