PC Review


Reply
Thread Tools Rate Thread

Change or hide Form Group Box outline

 
 
Tonso
Guest
Posts: n/a
 
      9th Jan 2012
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      10th Jan 2012
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



On 01/09/2012 08:26, Tonso wrote:
> 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
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:40 PM.