mandatory fields

how do I prevent a user updating cells on (e.g) worksheet2 if a task is not
completed on (e.g) workheet1?

Dawie
One way would be to use a Worksheet_Change event macro in worksheet2
that would fire if any changes are made in worksheet2. The code in that
macro would check worksheet1 for the task completion and would disallow the
changes if the worksheet1 task has not been completed. The same macro could
also display a message to the user saying whatever you want.
If this sounds like what you want, post back and provide some details about
the layout of your data. Include details about what would constitute
completion of the worksheet1 task and what range (the whole sheet?) in
worksheet2 you want to protect. HTH Otto
"dawie" wrote in message
...
how do I prevent a user updating cells on (e.g) worksheet2 if a task is
not
completed on (e.g) workheet1?