Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Button Color (Excel 2000)

    Hi ... this is rather minor (but you know users) .... Is it possible to change the color of a button on a worksheet. This button was created simply using the button on the Forms toolbar and I use these buttons to activate macros. I know I can change font color. Can the button itself change color. Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Button Color (Excel 2000)

    Hi,
    You can change the colour but you'd have to change the Windows Desktop settings to do it and it would have some (probably unpleasant) side effects!
    Alternatively if you use the Command button from the control toolbox, you can change the BackColor property of that quite easily.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    Jun 2001
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Button Color (Excel 2000)

    Yes -- instead of using the button on the forms toolbar, use the button from the control box toolbar. Then, right-click the button & bring up Properties window where you'll find you can change the forecolor/backcolor of the button. Right-click again for the View Code to associate it with code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •