RE: option button grouping

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hmm, must be something different between 2002 and 2003. See if there is
anything in the properties when you select multiple values that says the
sheet name. That or I think i remember you might be able to give each in the
group the same name one at a time. Sorry not a 100% sure though.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Pete" wrote:

When I select all of the buttons in a row a go to the properties there is no
place to assign a group name. Could you explain this further?

"John Bundy" wrote:

Hold down CTL and click each option button in the first row, then go to
properties and in the group name box give them a name, do the same thing to
the ones in row 3 giving them the SAME group name. Select all in row 2 and
give them a seperate group name, and finally give group 4 a group name the
same as you did for row 2. Thats a mouthfull.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Pete" wrote:

I know how to use option buttons and group the option buttons in a group box.
I have a worksheet in which I the option button groups are separated from
each other. Example (the numbers represent the option button group):

Row 1: 1 1 1 1
Row 2: 2 2 2 2
Row 3: 1 1 1 1
Row 4: 2 2 2 2

If I overlap the group boxes than the option buttons do not stay separated.
If I create 4 groups then Row 1 will not deselect when Row 3 is selected.
Help!

I'm using 2002 Excel.
.

Relevant Pages

  • Re: Multiple Instances of Word
    ... This can happen when you try and open or print multiple attachments ... > Graham Mayor - Word MVP ... > My web site www.gmayor.com ... > Pete Bennett wrote: ...
    (microsoft.public.word.docmanagement)
  • Re: Search
    ... Pete Wrote: ... Assuming the data is in Sheet1, insert a new sheet - I assume ... > It doesn't matter if you have multiple spaces between colours, ...
    (microsoft.public.excel.misc)
  • Re: 3D plots
    ... Peltier Technical Services ... Pete wrote: ... then reset the chart location to a new sheet. ...
    (microsoft.public.excel.charting)
  • Re: Payslip requirement?
    ... pete wrote: ... Even though it'll already have been sent via email between company and accountants? ... sheet of paper and 1 envelope, and a tiny amount of black printer ink once a month. ...
    (uk.legal)
  • Re: If ? maybe.....
    ... Biff ... >>> If the customer match and the orders match then do nothing. ... >>> If the customers match from Sheet to Sheet, but the order qtys do not ... >>> Pete ...
    (microsoft.public.excel.worksheet.functions)