editting pushbuttons
 

Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

editting pushbuttons
 

If You are mentioning command buttons then right clicking will enable
you to edit the text


Jean-Paul De Winter wrote:
Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

editting pushbuttons
 

Jean-Paul De Winter wrote:
Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

If the buttons are embedded controls, go to View - ToolBars - Control
Tool Box. One of the buttons on the toolbar toggles in and out of
design mode. While in design mode right click and select Properties.
Caption in one of the properties you can change. When done - make sure
that you exit design mode.

hth

-semiopen

editting pushbuttons
 

Also, here is a macro I use to change many from a vlookup table.

Sub NameShapes()
Sheets("checks").Select
For Each c In [setup!a4:a15]
ActiveSheet.Shapes(c).TextFrame. _
Characters.Text = c.Offset(0, 1)
Next c
End Sub

--
Don Guillett
SalesAid Software

"Jean-Paul De Winter" wrote in message
...
Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

editting pushbuttons
 

Problem solved.... thanks
JP

semiopen schreef:
Jean-Paul De Winter wrote:
Hi,
I have this excel worksheet I use for years now...
Ith has some pushbuutons to execute some code. Now I want to change the
text on this pushbuttons, but I forgot how I can edit those buttons... I
tried the combination of CTRL or Alt- enter key but... no way.
Doesn anybody know how?
Thanks
JP

If the buttons are embedded controls, go to View - ToolBars - Control
Tool Box. One of the buttons on the toolbar toggles in and out of
design mode. While in design mode right click and select Properties.
Caption in one of the properties you can change. When done - make sure
that you exit design mode.

hth

-semiopen

editting pushbuttons
 

On 24 Sep 2006 05:26:10 -0700, Abdul wrote:

If You are mentioning command buttons then right clicking will enable
you to edit the text

No. A "command" button is what is found on the Control Toolbox. Right
clicking only works for a Forms toolbar button (simply called a Button).
semiopen explained on to do it for a Control Toolbox button.

Don <www.donwiss.com (e-mail link at home page bottom).