| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Option Buttons in Group Box
I have two group boxes with two option buttons in each(from the Forms
Tool bar) Is there any way to make the group boxes invisible. I would like to have only the option buttons showing on the worksheet. |
|
#2
|
|||
|
|||
|
Set the BorderColor to the same color as the BackColor, and
change the SpecialEffect setting to 0 (fmSpecialEffectFlat). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JAMES T." wrote in message ups.com... I have two group boxes with two option buttons in each(from the Forms Tool bar) Is there any way to make the group boxes invisible. I would like to have only the option buttons showing on the worksheet. |
|
#3
|
|||
|
|||
|
alt-f11 to get to the VBE
ctrl-g to see the immediate window type (or copy|paste) activesheet.groupboxes.visible = false and hit enter "JAMES T." wrote: I have two group boxes with two option buttons in each(from the Forms Tool bar) Is there any way to make the group boxes invisible. I would like to have only the option buttons showing on the worksheet. -- Dave Peterson |
|
#4
|
|||
|
|||
|
I misread your question. I assumed you were talking about Option
Buttons on Userforms, not directly on the worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Set the BorderColor to the same color as the BackColor, and change the SpecialEffect setting to 0 (fmSpecialEffectFlat). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JAMES T." wrote in message ups.com... I have two group boxes with two option buttons in each(from the Forms Tool bar) Is there any way to make the group boxes invisible. I would like to have only the option buttons showing on the worksheet. |
|
#5
|
|||
|
|||
|
Thank goodness that never happens to me (cough, cough) <v,vbg.
Chip Pearson wrote: I misread your question. I assumed you were talking about Option Buttons on Userforms, not directly on the worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Chip Pearson" wrote in message ... Set the BorderColor to the same color as the BackColor, and change the SpecialEffect setting to 0 (fmSpecialEffectFlat). -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JAMES T." wrote in message ups.com... I have two group boxes with two option buttons in each(from the Forms Tool bar) Is there any way to make the group boxes invisible. I would like to have only the option buttons showing on the worksheet. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grouping of option buttons | Excel Discussion (Misc queries) | |||
| Excel option buttons | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Group buttons from the forms toolbar | Excel Discussion (Misc queries) | |||
| Can I use more than one set of option buttons in a worksheet? | Excel Worksheet Functions | |||
Linear Mode
