Change or hide Form Group Box outline


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
 
Ad

Advertisements

D

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
 

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

Top