ActiveX control
 

Hi,
Have an application whivh use a commandbutton embedded
in a worksheet to run a sub. When executing the sub from
the commandbutton nothing related to data validation,
conditional formatting etc. manifests itself in the sheet
even though the code is run through these bits. If i run
the sub from the VBE using F5 everything is working
properly. Is there a way around this problem? Does
activeX controls make certain parts of Excel unavailable
while active.
Running on XP

any help appreciated.

ActiveX control
 

Not sure without seeing your code, but you could try
putting the code in a macro and then calling the macro
from the button on the sheet.

Libby
-----Original Message-----
Hi,
Have an application whivh use a commandbutton embedded
in a worksheet to run a sub. When executing the sub from
the commandbutton nothing related to data validation,
conditional formatting etc. manifests itself in the sheet
even though the code is run through these bits. If i run
the sub from the VBE using F5 everything is working
properly. Is there a way around this problem? Does
activeX controls make certain parts of Excel unavailable
while active.
Running on XP

any help appreciated.
.