Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
ActiveX Control text box | Excel Worksheet Functions | |||
ActiveX control with chart | Charts and Charting in Excel | |||
sumif from activeX control | Excel Worksheet Functions | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) |