Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Help with combo boxes and macros in Excel 2003 | Excel Discussion (Misc queries) | |||
Filtered list for Combo Box ListFillRange - Nested Combo Boxes | Excel Programming | |||
Using Combo boxes in excel | Excel Programming |