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
|