Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Guys
I have not used ActiveX controls on a sheet before, so any help gratefully received. I have a worksheet with some activeX command buttons, each are set manually using the control properties to enabled = false. In my VBA code module I am trying to use the following to enable the controls, in this case the command name is cbTotals, however this does not work :-( Sheets(1).OLEObjects("cbTotals").Object.Enabled = True Something simple I'm sure but I've tried various permutations without success Cheers Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Definitions for Activex control properties? | Excel Worksheet Functions | |||
How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
Return ActiveX properties by means of a variable??? | Excel Programming | |||
ActiveX Chart Properties in Excel 2000 | Excel Programming |