If you are prepared to use VBA
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
"Duplatt" wrote in message
...
Is it possible to lock and unlock cells on one sheet based on certain
criteria in a certain cell on another sheet ?