View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Phil Phil is offline
external usenet poster
 
Posts: 15
Default 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