Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dragging Validated Value with Protection
I have a Worksheet that employees will select their initials from a
validation list for a given time frame. Those initials are then counted for each time period per initial at the top of the sheet. I need to have the count calculations protected. I want the employess to be able to drag their initials across columns (rather than click each cell and choose from the list or type)but when I put the protection on the sheet it does not let me do that even though those cells are not locked. I only have the count formula cells locked. Any ideas? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max value in validated list | Excel Discussion (Misc queries) | |||
validated lookup | Excel Worksheet Functions | |||
Tab from a Validated Cell to another | Excel Discussion (Misc queries) | |||
Using 'OR' with validated data | Excel Worksheet Functions | |||
Validated cells and IF statements | Excel Discussion (Misc queries) |