| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group box border visibility control
Hi and Help
I am using the 'group box' command (Forms toolbar) to group multiple option buttons (also in the Forms toolbar) through out a worksheet. The group box has a line border and text that I do not want to see when I am in the workbook. I can delete the text but I cannot find a way to control the border. The border does not show show when printing. I can toggle the group box in Form Control, control tab, to 3D and the border greys out. Can still see it. How do I control the visibility of the border in a 'group box' . Excel 2003 Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Group box border visibility control
You can hide the groupbox in code. Or with just a one liner:
Hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter. activesheet.groupboxes.visible = false teishin wrote: Hi and Help I am using the 'group box' command (Forms toolbar) to group multiple option buttons (also in the Forms toolbar) through out a worksheet. The group box has a line border and text that I do not want to see when I am in the workbook. I can delete the text but I cannot find a way to control the border. The border does not show show when printing. I can toggle the group box in Form Control, control tab, to 3D and the border greys out. Can still see it. How do I control the visibility of the border in a 'group box' . Excel 2003 Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Group box border visibility control
Way cool....many thanks
"teishin" wrote: Hi and Help I am using the 'group box' command (Forms toolbar) to group multiple option buttons (also in the Forms toolbar) through out a worksheet. The group box has a line border and text that I do not want to see when I am in the workbook. I can delete the text but I cannot find a way to control the border. The border does not show show when printing. I can toggle the group box in Form Control, control tab, to 3D and the border greys out. Can still see it. How do I control the visibility of the border in a 'group box' . Excel 2003 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell border colors in Excel | Excel Discussion (Misc queries) | |||
| Control cursor direction in highlighted group of cells/Page setup | Excel Worksheet Functions | |||
| How do I set up and use a group box form control? | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| border color in forms group box | Excel Discussion (Misc queries) | |||
Linear Mode
