ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Button (https://www.excelbanter.com/excel-discussion-misc-queries/32576-macro-button.html)

Maggie

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

Norman Jones

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




Maggie

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





Norman Jones

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