Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro Button
I need to change the background color of a button created to execute a macro
and change the word wrap property to true so all of the text can be viewed on the button. Any advise is much appreciated. Thanks |
#2
|
|||
|
|||
Hi Maggie,
Assuming that the button is from the Controls Toolbox, Right-click the button | Properties Double-click the 'BackColor' option | Palette and select a color Double-click the 'WordWrap' option (to select True) Close the Properties window --- Regards, Norman "Maggie" wrote in message ... I need to change the background color of a button created to execute a macro and change the word wrap property to true so all of the text can be viewed on the button. Any advise is much appreciated. Thanks |
#3
|
|||
|
|||
Thank you for your help. I was using the forms toolbar.
"Norman Jones" wrote: Hi Maggie, Assuming that the button is from the Controls Toolbox, Right-click the button | Properties Double-click the 'BackColor' option | Palette and select a color Double-click the 'WordWrap' option (to select True) Close the Properties window --- Regards, Norman "Maggie" wrote in message ... I need to change the background color of a button created to execute a macro and change the word wrap property to true so all of the text can be viewed on the button. Any advise is much appreciated. Thanks |
#4
|
|||
|
|||
Hi Maggie,
I do not believe that you can change the background color of buttons from the Forms toolbar and, in my experience, the button caption text wraps. Why not use a button from the Control toolbox. These are much more flexible and provide access to the teo properties that you want to control. --- Regards, Norman "Maggie" wrote in message ... Thank you for your help. I was using the forms toolbar. "Norman Jones" wrote: Hi Maggie, Assuming that the button is from the Controls Toolbox, Right-click the button | Properties Double-click the 'BackColor' option | Palette and select a color Double-click the 'WordWrap' option (to select True) Close the Properties window --- Regards, Norman "Maggie" wrote in message ... I need to change the background color of a button created to execute a macro and change the word wrap property to true so all of the text can be viewed on the button. Any advise is much appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
Change caption on a macro button | Excel Worksheet Functions | |||
2 part question - macro / command button | Excel Discussion (Misc queries) | |||
How to assign a macro to a commnd button | Excel Discussion (Misc queries) |