Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
editting a template | New Users to Excel | |||
macro editting | Excel Programming | |||
Hexidecimal Editting | Excel Programming | |||
Possible to see which user is editting/using file? | Excel Programming | |||
Editting Formulas Using a Macro | Excel Programming |