data control

[aoc]

dear all,


if the user made a character or comment change in a any cell on sheet1 beginning from 4th row and clicks to leave excel, a message box will come saying " you made changes at cells ...., did you fill bw bx columns ". If the user clicks yes, he will be able to leave, if clicks no, he will not be able to leave before filling the cells in bw bx which are in the changed row.

can you please give the vb code ?

[GTO]

Greetings Osman,

This is the same as thread http://www.vbaexpress.com/forum/showthread.php?p=187900#post187900

If the user makes a change to a given cell, we can do something in response using the Worksheet_Change event. I'm not so sure about capturing a change to a comment.

I suppose we could also use the EnableSelection property (if the sheet is or can normally remain protected) to disallow cell selection out of a certain range.

Do you have any code thus far, and/or an example workbook you could post?

Mark

[aoc]

hi

please check the attached doc, I don t have any code.

[aoc]

hi

could you check the file



hi

please check the attached doc, I don t have any code.

[GTO]

It is password protected?

[aoc]

yes, password is emhata