#1   Report Post  
Maggie
 
Posts: n/a
Default 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   Report Post  
Norman Jones
 
Posts: n/a
Default

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   Report Post  
Maggie
 
Posts: n/a
Default

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   Report Post  
Norman Jones
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create a command button, then assign macro to it in excel kshaheen Excel Discussion (Misc queries) 3 June 24th 08 01:03 PM
How do I Assign Macro to a button? BellExcel Charts and Charting in Excel 4 May 20th 05 07:21 PM
Change caption on a macro button gbeard Excel Worksheet Functions 3 April 21st 05 01:43 PM
2 part question - macro / command button John Excel Discussion (Misc queries) 3 April 16th 05 09:00 PM
How to assign a macro to a commnd button Mickey Blue Eyes Excel Discussion (Misc queries) 2 January 4th 05 02:15 PM


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"