Invisible Group Box for Form Controls

[naznorb]

Hi,

I need to group some option buttons (Form controls). Can't use ActiveX or VBA per client. (I'm using Excel 2007.)

Stylistically, I can't really accept the visible, hardly-formattable group box.

Is there any way to make that box invisible, or another solution to this, or am I stuck?

Many thanks for any help.

J

 

[Jaafar Tribak]

Maybe something along these lines via VBA:

Sheets(1).Shapes("YourGroupBoxName").Visible = False

Change the sheet name/index and the Shape (ie GroupBox) name to suit.

I couldn't find a way to set this Visible Property via the UI.

Regards.

 

[brites]

I just had the same problem and found this solution:

You dont need a macro, just a code.

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:
activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.

If you are running excel2007 it means you dont even need to save as a macro workbook, a regular file will do it.

Cheers!

 

[tangcla]

I just had the same problem and found this solution:

You dont need a macro, just a code.

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:
activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.

If you are running excel2007 it means you dont even need to save as a macro workbook, a regular file will do it.

Cheers!

Just wanted to say this saved me lots of headache. After spending a few hours looking up ways to get things grouped, this was tye best and easiest way of doing it.

Thanks brites!

 

[Papi]

Should this work for Excel 2010?

 

[Papi]

Invisib

 

[Rick Rothstein]

Hi,

I need to group some option buttons (Form controls). Can't use ActiveX or VBA per client. (I'm using Excel 2007.)

Stylistically, I can't really accept the visible, hardly-formattable group box.

Is there any way to make that box invisible, or another solution to this, or am I stuck?

If you select the Group Box, right-click the shaded border that surrounds it, select "Edit Text" from the popup menu that appears and remove all the characters, you will be left with a simple rectangle... maybe that will look better to you?

 

[Papi]

Much nicer. Thanks very much Rick.

 

[Papi]

Some of the boxes only show on the top and left yet they seem to be sized right for the number of buttons. Any idea what causes this?

 

[Rick Rothstein]

Some of the boxes only show on the top and left yet they seem to be sized right for the number of buttons. Any idea what causes this?

The rectangle is well-formed and complete on my copies of XL2003, XL2007 and XL2010. Two things I can think of that might affect the viewing of the rectangle... first, make sure your zoom level is 100% (other values might affect the display of thin lines); second, select the Group Box, right-click the shaded border but this time select "Format Control" from the popup menu, click the "Control" tab and make sure the "3-D shading" check box is not checked (the rectangle border seem much thinner when it is checked). Other than that, I am not sure what to tell you as I cannot make what you are describing happen on my system.