Programmatically adding buttons to a worksheet (Shape Object)
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
|