View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Hi Kathy,

1) You don't add them to cells, you place them on the worksheet. You can
align with cells, but they are not part of that cell. Just click the
checkbox, and then draw it on the worksheet.

2) I don't think you can put that it the DV box, but you can put that text
in the cell above.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kathy" wrote in message
...
Two questions:

1) How do I add check boxes to items? I see the check box on the Control
Toolbar but how do I add them to cells? Does the worksheet need to be
protected first?

2) There is a drop down list of items already in a cell on the

spreadsheet.
It is not visible until one clicks the cell. Then you see the arrow and

the
list. I would like to get into the list to put a value at the top that

says
"choose an option" AND have that option show so that people know to click

the
cell. Again, do I need to protect the worksheet?

Thanks very much,
Kathy