View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR[_2_] CAPTGNVR[_2_] is offline
external usenet poster
 
Posts: 87
Default To change command button caption

Sorry- figured it out and the below code works.
ActiveSheet.OLEObjects("alfa").Object _
..Caption = "GO TO CARGO"

can consider this thread closed.

"CAPTGNVR" wrote:

Dear All
I am in sheet2.
I click a custom tool bar item, then it has to goto sheet1 and change
command button in sheet1 by name 'alfa" caption from "go to ballast" to "go
to cargo" .

Have been getting error when using activesheet.shapes.("alfa").caption= "go
to cargo"

Pls suggest right code n thnks

brgds/captgnvr