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.
.