MS Excel 2003 Combo Boxes
 

I have designed a spreadsheet that includes a series of combo boxes at the
top of columns. These boxes contain information that can be dragged and
dropped into a cell in the spreadsheet. On occasion, when the spredsheet is
given to a user to fill in, one or more of the combo boxes moves to another
location on the spreadsheet independently and without warning. This happens
even though the spreadsheet is protected so that a user cannot access or
modify the box or the cell where it resides. Under Format Control the
properties are set to move, but not size the box with the cell. How can I
ensure that the combo box will stay with the cell within which it resides?

MS Excel 2003 Combo Boxes
 

change it to Don't move or size with cells.


--
Regards,
Tom Ogilvy



"RFS1996" wrote:

I have designed a spreadsheet that includes a series of combo boxes at the
top of columns. These boxes contain information that can be dragged and
dropped into a cell in the spreadsheet. On occasion, when the spredsheet is
given to a user to fill in, one or more of the combo boxes moves to another
location on the spreadsheet independently and without warning. This happens
even though the spreadsheet is protected so that a user cannot access or
modify the box or the cell where it resides. Under Format Control the
properties are set to move, but not size the box with the cell. How can I
ensure that the combo box will stay with the cell within which it resides?