To change command button caption

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
 
C

CAPTGNVR

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

can consider this thread closed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command button continues to be visible! 11
Copied sheet not to have links 2
Command Button Caption - VBA 2
How to change textbox caption in Active sheet from UserForm 4
How to export a linked cell sheet to get only values. 3
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Change Caption of Button 3
How can I programatically change the caption on a button? 3

Top