To change command button caption

  • Thread starter Thread starter CAPTGNVR
  • Start date Start date
C

CAPTGNVR

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
 
Sorry- figured it out and the below code works.
ActiveSheet.OLEObjects("alfa").Object _
..Caption = "GO TO CARGO"

can consider this thread closed.
 
Back
Top