Change or hide Form Group Box outline

[Tonso]

Can I change the color of the Group Box outline. It is currently
black, and I would want it white so it is invisible, or gray if I use
a gray background.
I am using it in XL2003 to put 2 Option buttons in.


Thanks,

Tonso

 

[Dave Peterson]

You'll have to use VBA to make the groupbox invisible.

activesheet.groupboxes.visible = false
will work for a small (whatever that means) number of groupboxes.

But if you have lots, you can use:

dim GBX as groupbox
for each GBX in activesheet.groupboxes
gbx.visible = false
next gbx