border color in forms group box

G

Guest

Is it possible to change the border color in a forms group box? I have a
couple of options buttons in groups, however I do not want the black box
surrounding the options buttons to show on the spreadsheet.

Thank you.
 
D

Dave Peterson

You can hide that border via code--but I don't think you can change the color.

You could run a small macro:


Option Explicit
Sub testme()
'for just the one named "group box 1")
ActiveSheet.GroupBoxes("group box 1").Visible = False
'or for all of them
ActiveSheet.GroupBoxes.Visible = False
End Sub


or just issue the command from the immediate window inside the VBE.
Hit Alt-f11 to get to the VBE
hit ctrl-g to get to the immediate window

Type the one you want:

ActiveSheet.GroupBoxes("group box 1").Visible = False

ActiveSheet.GroupBoxes.Visible = False

and hit enter.

You can find the name of the (visible) groupbox by selecting it and looking at
the namebox (to the left of the formulabar).

(Toggle False to True when you want to see them to modify your groupboxes.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group box border visibility control 2
Control Box Properties 1
Formatting option buttons & group box 1
page borders 3
Borders Line Colors 2
Changing Border buttons on the toolbar 1
line appears in text box when printing in color 2
Checkbox to change background color, font color and remove/ add bo 1

Top