Group Box Format (Excel 97 SR1 NT4)

Topic

New Reply

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!

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

Ahh! The ol’ cover it with a blank box! Silly me for not thinking of it sooner!

Thanks for the quick help!!

Reply | Quote