| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I.....
edit the text on a command button. I know I've done it before, but for the life of me I can't figure it out and googling my problem dosen't help either. So can anyone point me in the right direction? Thanx :) -- SCOTTF ------------------------------------------------------------------------ SCOTTF's Profile: http://www.excelforum.com/member.php...o&userid=37672 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
SCOTTF Wrote: edit the text on a command button. I know I've done it before, but for the life of me I can't figure it out and googling my problem dosen't help either. So can anyone point me in the right direction? Thanx :) Hi SCOTTF, Can't you right click on it, then edit text? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
oh believe me I've tried, many many times! that is the easiest answer, but won't work....anything else? thanx! -- SCOTTF ------------------------------------------------------------------------ SCOTTF's Profile: http://www.excelforum.com/member.php...o&userid=37672 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
SCOTTF Wrote: oh believe me I've tried, many many times! that is the easiest answer, but won't work....anything else? thanx! Ask a simple question - as they say. How about Protection? oldchippy  -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
sheet is not protected. i can create the button...assign the macro to it clicking the button executes the macro perfectly...but i CAN NOT change the text in the button.... it says "CommandButton1". I want it to say "Generate Next PO". other people may need to use this spreadsheet... they'll need to know the function of the button....thanx for taking the time to help me plow thru this!  Scott -- SCOTTF ------------------------------------------------------------------------ SCOTTF's Profile: http://www.excelforum.com/member.php...o&userid=37672 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
Choose ViewToolbarsControl Toolbox
Click the Design Mode button Select the CommandButton1, and click the Properties button on the Control toolbox In the Caption box, type "Generate Next PO" Close the Properties window Click the Exit Design Mode button SCOTTF wrote: sheet is not protected. i can create the button...assign the macro to it clicking the button executes the macro perfectly...but i CAN NOT change the text in the button.... it says "CommandButton1". I want it to say "Generate Next PO". other people may need to use this spreadsheet... they'll need to know the function of the button....thanx for taking the time to help me plow thru this! Scott -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
:) :) :) :) THANX!!!! Debra...worked perfectly. Gracias!!!!!! -- SCOTTF ------------------------------------------------------------------------ SCOTTF's Profile: http://www.excelforum.com/member.php...o&userid=37672 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
You're welcome! Thanks for letting me know that it worked.
SCOTTF wrote: :) :) :) :) THANX!!!! Debra...worked perfectly. Gracias!!!!!! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I.....
I think I have found it.
Rightclick on button go to prioridades (sorry, I have the Spanish Excel) put your name under "Caption" and you have named the button. Regards, Bob SCOTTF ha escrito: sheet is not protected. i can create the button...assign the macro to it clicking the button executes the macro perfectly...but i CAN NOT change the text in the button.... it says "CommandButton1". I want it to say "Generate Next PO". other people may need to use this spreadsheet... they'll need to know the function of the button....thanx for taking the time to help me plow thru this! Scott -- SCOTTF ------------------------------------------------------------------------ SCOTTF's Profile: http://www.excelforum.com/member.php...o&userid=37672 View this thread: http://www.excelforum.com/showthread...hreadid=572784 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
