Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Running xl2003 & xl2007. I知 hoping someone can point out to me what I知 missing here. I turn on the macro recorder, and add an ActiveX control to the worksheet. I then right click on the control, and I see the Properties & View Code menu items. As I壇 expect. Sub Macro3() ActiveSheet.OLEObjects.Add(ClassType:="Forms.Comma ndButton.1", Link:=False _ , DisplayAsIcon:=False, Left:=143.25, Top:=59.25, Width:=96, Height:= _ 45.75).Select End Sub Now I run the above macro recorder code, and a new control is added to the worksheet. But when I right click on this control, the Properties & View Code items are missing. Why? Thank you, Regards, DaveU |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Definitions for Activex control properties? | Excel Worksheet Functions | |||
How do I change activex control properties from a macro | Excel Discussion (Misc queries) | |||
ActiveX properties in VB and VBA | Excel Programming | |||
ActiveX Control Properties | Excel Programming | |||
Return ActiveX properties by means of a variable??? | Excel Programming |