Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jun 2001
    Location
    Burlington, Ontario, Canada
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Group Box Format (Excel 97 SR1 NT4)

    Greetings and Salutations one and all!

    I am creating an excel worksheet form (not a true form) and have grouped several option buttons together. I am trying to keep it as simple as possible for the end user so the question is - Is there any way to eliminate the border of the Group Box so as to not detract them?

    I have eliminated the Group Box text and have also removed - Print Object. To the best of your collective knowledge can I remove the borders or at least change the colour?

    Any thoughts,

    Thanks in advance!

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Group Box Format (Excel 97 SR1 NT4)

    John

    Not on a worksheet. On a userform you can make it different colors, but on a worksheet your edits are limited.

    How about if you position the frame so that the cell borders will mask it?

    Sorry, and enjoy life as well. Will you get a full refund or is it prorated according to your age?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Group Box Format (Excel 97 SR1 NT4)

    Salutations to you too,

    You could use a workaround. Create a rectangle shape the same size as the Group Box. Set the fill color to transparent and the line color to your background color. You should also set the line weight to 3 points or thereabouts. Next select the Group Box and all it's contents (option buttons in your case) and from the draw toolbar/menu select Group. Next select the goup and the rectangle and again from the Draw menu select first Align Center, then Align middle. Next again from the Draw menu select group.

    Hopefully that will give you what you want.

    Andrew C

  4. #4
    Lounger
    Join Date
    Jun 2001
    Location
    Burlington, Ontario, Canada
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Group Box Format (Excel 97 SR1 NT4)

    Ahh! The ol' cover it with a blank box! <img src=/S/doh.gif border=0 alt=doh width=15 height=15> Silly me for not thinking of it sooner!

    Thanks for the quick help!!

Posting Permissions

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