|
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. |
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. |
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 |
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. |
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 |
| All times are GMT +1. The time now is 05:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com