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

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