Change or hide Form Group Box outline

  • Thread starter Thread starter Tonso
  • Start date Start date
T

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
 
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
 
Back
Top