Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel option buttons
A big thanks to Dave Peterson for the tip about grouping the options buttons!
I was wondering if there is any way to hide the group box outline after I have created it. I'd rather not see it around the buttons. Thanks for any help you can provide. |
#2
|
|||
|
|||
These were from the Forms toolbar, right?
Saved from a previous post: You could run a small macro: Option Explicit Sub testme() 'for just the one named "group box 1") ActiveSheet.GroupBoxes("group box 1").Visible = False 'or for all of them ActiveSheet.GroupBoxes.Visible = False End Sub or just issue the command from the immediate window inside the VBE. Hit Alt-f11 to get to the VBE hit ctrl-g to get to the immediate window Type the one you want: ActiveSheet.GroupBoxes("group box 1").Visible = False ActiveSheet.GroupBoxes.Visible = False and hit enter. You can find the name of the (visible) groupbox by selecting it and looking at the namebox (to the left of the formulabar). (Toggle False to True when you want to see them to modify your groupboxes.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Tosty wrote: A big thanks to Dave Peterson for the tip about grouping the options buttons! I was wondering if there is any way to hide the group box outline after I have created it. I'd rather not see it around the buttons. Thanks for any help you can provide. -- Dave Peterson |
#3
|
|||
|
|||
Thanks so much for all the help Dave! You guys are the best!
"Dave Peterson" wrote: These were from the Forms toolbar, right? Saved from a previous post: You could run a small macro: Option Explicit Sub testme() 'for just the one named "group box 1") ActiveSheet.GroupBoxes("group box 1").Visible = False 'or for all of them ActiveSheet.GroupBoxes.Visible = False End Sub or just issue the command from the immediate window inside the VBE. Hit Alt-f11 to get to the VBE hit ctrl-g to get to the immediate window Type the one you want: ActiveSheet.GroupBoxes("group box 1").Visible = False ActiveSheet.GroupBoxes.Visible = False and hit enter. You can find the name of the (visible) groupbox by selecting it and looking at the namebox (to the left of the formulabar). (Toggle False to True when you want to see them to modify your groupboxes.) If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Tosty wrote: A big thanks to Dave Peterson for the tip about grouping the options buttons! I was wondering if there is any way to hide the group box outline after I have created it. I'd rather not see it around the buttons. Thanks for any help you can provide. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I enter a working check box option in Excel? | Excel Discussion (Misc queries) | |||
What happened to Subscript and Superscript Buttons in Excel? | Charts and Charting in Excel | |||
Limitation of Autofiltr option in Excel | Excel Worksheet Functions | |||
Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions |