Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
I just created using the Forms Toolbar a Command Button
assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Jim,
Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Another Q:
How do I even Delete a Forms Command Button? Grrrr... TIA, -----Original Message----- I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Right-click and select the Cut option.
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Another Q: How do I even Delete a Forms Command Button? Grrrr... TIA, -----Original Message----- I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Bob:
When I right-click on the button nothing happens; When I move the mouse over the button the Hand-in-Glove appears (and the macro runs if I left-click on it). Now I just want to delete the button and create a new button for the same macro and this time rename it before exiting out. Tks, Jim -----Original Message----- Jim, Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Jim,
Is the worksheet protection (ToolsProtection)? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Bob: When I right-click on the button nothing happens; When I move the mouse over the button the Hand-in-Glove appears (and the macro runs if I left-click on it). Now I just want to delete the button and create a new button for the same macro and this time rename it before exiting out. Tks, Jim -----Original Message----- Jim, Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
No, it is not.
-----Original Message----- Jim, Is the worksheet protection (ToolsProtection)? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Bob: When I right-click on the button nothing happens; When I move the mouse over the button the Hand-in-Glove appears (and the macro runs if I left-click on it). Now I just want to delete the button and create a new button for the same macro and this time rename it before exiting out. Tks, Jim -----Original Message----- Jim, Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
if this button is on a spreadsheet (rather than a userform), first click on
the 'design mode' button (turqoise set-square image on my pc), then you can left-click to select or right-click to bring up the short-cut menu - make sure you turn deisgn mode off again, to be able to click on it and make it work. hth, tim wrote in message ... No, it is not. -----Original Message----- Jim, Is the worksheet protection (ToolsProtection)? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Bob: When I right-click on the button nothing happens; When I move the mouse over the button the Hand-in-Glove appears (and the macro runs if I left-click on it). Now I just want to delete the button and create a new button for the same macro and this time rename it before exiting out. Tks, Jim -----Original Message----- Jim, Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . . |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
i think you must've created it from the 'control toolbox' toolbar rather
than the 'forms' toolbar? wrote in message ... No, it is not. -----Original Message----- Jim, Is the worksheet protection (ToolsProtection)? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... Bob: When I right-click on the button nothing happens; When I move the mouse over the button the Hand-in-Glove appears (and the macro runs if I left-click on it). Now I just want to delete the button and create a new button for the same macro and this time rename it before exiting out. Tks, Jim -----Original Message----- Jim, Select the button by right-clicking it (it will be surrounded by a grey hatching), then use the mouse to select the button text, and over-type it. -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim . . |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Caption of Forms Command Button
Hold down the Ctrl key while Left clicking the button. Then just start
typing to change the caption. or click your delete key to delete it. " wrote: I just created using the Forms Toolbar a Command Button assigning a Macro to it; Unfortunately It shows "Button 14" without the quotes.. When I right-click on the button I'd expect a short-cut menu to come up with Format, etc. but nothing happens. be able to alter it. How can I change the caption? TIA, Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change caption of a button | Excel Worksheet Functions | |||
Forms Command Button - Removal | Excel Discussion (Misc queries) | |||
Command button on forms | Excel Discussion (Misc queries) | |||
Change caption on a macro button | Excel Worksheet Functions | |||
Urgent: VBA Command Button Caption Problem | Excel Programming |