[mso] Re: I need to hide the line in a group box in Excel
- From: "Sandy Crowley" <SCrowley@xxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 17 Dec 2003 13:43:53 -0500
Thanks all. Ray, I had just started putting the "white" lines around to
mask when I got your suggestion. Thanks Linda and Ray for the tips.
Linda, the "group box" is on the Form toolbar.
Sandy Crowley, SDA, CDT=20
Little Diversified Architectural Consulting
D:704.561.5135 | M:704.408.0458 | F:704.561.8777
www.littleonline.com
=20
-----Original Message-----
From: Ray Blake [mailto:ray@xxxxxxxxx]=20
Sent: Wednesday, December 17, 2003 12:48 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: I need to hide the line in a group box in Excel
Sandy,
This can't be done, even using the Shape.Line property in VBA. If you
really just can't live with the group box, consider using coded ActiveX
versions of the controls instead, although you'll need to write some VBA
to get the same functionality. You can find these controls in the
'controls toolbox' icon bar.
One alternative - if you have gridlines hidden on your sheet - would be
to place a box over the option box, set the fill colour to 'no fill' and
the border to white. You might need to play with the line thickness, but
this will mask the group box outline. It will also mask the cell
gridlines, hence not ideal unless you have them hidden.
Ray
Ray
_____________
This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.
For more information on the services that we offer please visit us at
our website: - www.grbps.com=20
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandy Crowley
Sent: 17 December 2003 17:07
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: I need to hide the line in a group box in Excel
Excel XP 2002. I'm using the Form toolbar with the controls on it. I
don't want them all to be grouped since each line needs its own answer.
B19:G19 have option buttons that need to be grouped and the next row
needs its own grouping as well. Does this clarify?
Sandy Crowley, SDA, CDT=3D20
Little Diversified Architectural Consulting
D:704.561.5135 | M:704.408.0458 | F:704.561.8777
www.littleonline.com
=3D20
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]=3D20
Sent: Wednesday, December 17, 2003 12:09 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: I need to hide the line in a group box in Excel
What version of Excel and how did you create the Option buttons? Did
you use the Control toolbox? I'm doing this in Excel 2003 and I see no
"group box"....when I enter Option buttons in this version, using the
Control toolbox, they are automatically grouped so selecting one
deselects the other...so tell me which version of Excel you are doing
this in and I will see if it's different there.
Heading out the door now tho, so I won't answer this until later tonite.
Linda F. Johnson, M.A., MOS
Linda's Computer Stop
http://personal-computer-tutor.com
Free e-Books, Newsletter, and tutorials
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Sandy Crowley
Sent: Wednesday, December 17, 2003 11:48 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] I need to hide the line in a group box in Excel
I have created option buttons for several rows of questions. Each row
contains five option buttons and the user can only select one per
question. I have grouped the option buttons with a group box and I need
to hide the Line around the buttons. I can delete the text but can't
figure out how to delete the line. HELP!!!! =3D20 Sandy Crowley, SDA, =
CDT
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=3D20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will
also allow you to change your email settings to digest or vacation (no
mail). //www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions. Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
