controls like check boxes and combo boxes cannot be
assigned to cells. they sit on top of the sheet. to get
them on the sheet simple click the icon on the tool bar
then click a place on the sheet and drag right and down.
the contol's "size" depend on how much you drag.
once on the sheet, right click the control. click and set
properties. you may also assign code.
-----Original 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
.
|