You can hide the groupbox via code:

All of them:
activesheet.groupboxes.visible = false

or (one by one)
activesheet.groupboxes("group box 1").visible = false



Jason wrote:

Chip,

Not the frame control. I see how you can remove the
border there. This is called a Group Box - you can get
to it by clicking View | Toolbars | Forms. Its the icon
with the xyz on the top.

I don't see anyway in removing the border or changing the
border color.
-----Original Message-----
Jason,

Are you talking about a Frame control on a User Form?
Set the
BorderStyle property to frmBorderStyleNone.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jason" wrote in
message
...
Is there any way to format the group box form control
to
hide the border? If not, can you change the color of
the
border?


.


--

Dave Peterson