Option Buttons in Group Box

J

JAMES T.

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.
 
C

Chip Pearson

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
 
D

Dave Peterson

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
 
C

Chip Pearson

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
 

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

Formatting option buttons & group box 1
option buttons / group box 1
Can't get Forms option bjuttons into a Group box 3
Access Create option group without using wizard? 2
Option Groups: Can I Group the Buttons AND the Box They're In? 2
Options Button (forms Contrrol) 1
link option buttons on multiple sheets 3
Option Buttons in a Form 7

Top