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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com