Form Controls - Group Box

  • Thread starter Thread starter MaryM
  • Start date Start date
M

MaryM

Is there any way to make the group box borders invisible?
I see a setting to not print, but I dont want them visible on scree
either.

I am using Excel 2002 SP2

Thanks in advance
 
I don't think you can do this except via code.

Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window

type this in and hit enter:

activesheet.groupboxes.visible = false

This hides all the groupboxes on the activesheet.
 
You must log in or register to reply here.

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

Similar Threads

Group box border visibility control 2
Control Box Properties 1
White Text on Screen, not visible on paper 1
Access Create option group without using wizard? 2
Option Buttons in Group Box 4
Formatting option buttons & group box 1
Print Button help 2
Can I group controls together and apply code to the group 5

Back
Top