If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
mandatory fields
how do I prevent a user updating cells on (e.g) worksheet2 if a task is not
completed on (e.g) workheet1? |
#2
|
|||
|
|||
mandatory fields
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? |
Thread Tools | |
Display Modes | |
|
|