Invisible Group Box for Form Controls

naznorb

Board Regular
Joined
Nov 24, 2009
Messages
51
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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Maybe something along these lines via VBA:

Code:
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.
 
Upvote 0
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!
 
Upvote 0
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!
 
Upvote 0
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?
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top