Copy value from Date Picker to a protected cell?

[dbant2009]

I have created a date picker to have a user select a date that will also place that value to a protected cell. I don't want to have users type a date in the field because errors can occur. When I protect the sheet and select the date it won't update the cell because of the protection. Is there any way to do this with out taking protection off and then turning it back on again. Usimg Excel 2007 and Excel 2003

 

[SkipVought]

hi,

Is there any way to do this with out taking protection off and then turning it back on again.

That is EXACTLY what to do.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Scott24x7]

Dbant2009
What you could do, is save the value either in a hidden cell, row way down "the way" (like A2000). Users will never scroll down, and to make it harder for them to notice if they do, make it white text on white background. THEN, in your "protected cell" you don't want them to type in, reference the cell that is "unprotected" at range A2000 with =A2000 in that protected cell. It will display the changed data without placing the value in that cell.

Tricky, but works better than turn on turn off, and users won't realize they can force the value in to this cell way down the bottom anyway.
Hope this helps.


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."