You have to use code.

One way:
select your worksheet
alt-f11 to see the VBE
ctrl-g to see the immediate window
type this and hit enter

Activesheet.groupboxes.visible = false

If it blows up (it might if you have lots of these groupboxes), you can run a
macro:

option explicit
sub testme()
dim myGB as groupbox
for each myGB in activesheet.groupboxes
mygb.visible = false
next mygb
end sub

cbh35711 wrote:

yeah painfully easy :)
OK here's another question.
How can i get those Group box 338 or whatever to not be there?
I want the groups, but i don't want it to print or be seen by user.

Thanks a lot,

Chris

--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=499445

--

Dave Peterson