+ Reply to Thread
Results 1 to 7 of 7

Button (Form Control) should in Blue Color

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Button (Form Control) should in Blue Color

    Dear All

    I have a sheet where i use Buttons for operating Macros I want to change it colors to Blue or Red.

    Your precious guide needed.

    Regards

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Button (Form Control) should in Blue Color

    You can change the Font Color of form buttom but you can't change the BackGround Color. Make use of Insert>>Shapes


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Button (Form Control) should in Blue Color

    I use Insert >> Shapes but it not give Button Pressing Impression.......

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Button (Form Control) should in Blue Color

    Do right click on the shape and select assign macro, once you assigned the macro then you can...

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Button (Form Control) should in Blue Color

    you could use an activex button if the color is really important
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  6. #6
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    178

    Re: Button (Form Control) should in Blue Color

    i use Active X button but unable to assign Macro to this....... ???

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Button (Form Control) should in Blue Color

    You have to call the Maco.

    Right Click the button>>Select View Code>> Inside the event call your macro like this Call mymacro

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1