Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
As far as I am aware, OleObjects is the controls toolbox collection, whereas
your original code create a forms button. I don't see the two bits workintg together. Bob "Phil" wrote in message ... Thanks Bob, but that doesn't work. We found the answer, it's meant to be referenced as an Object in the OLEObjects collection... so while this is no good: SheetName.OLEObjects(SheetName.OLEObjects.Count).C aption = "test" this is ok: SheetName.OLEObjects(SheetName.OLEObjects.Count).O bject.Caption = "test" thanks anyway... Philip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to tell wich object/shape was clicked | Excel Programming | |||
XL2000: Shape object events | Excel Programming | |||
Hyperlink within the TextFrame of Shape Object..? | Excel Programming | |||
How to hide Excel window when activating a Shape object | Excel Programming | |||
How to hide Excel window when activating a Shape object | Excel Programming |