mandatory fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a cell to be blank. 4
How do I use the text content of a cell as a worksheet reference? 9
Coppy formula using OFFSET 4
cell shows 0 when referenced cell is null 8
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
link cell to open a worksheet 1
Lookup or Match with rows and column together 5
Help-IF Function 2

Back
Top