aoc
06-17-2009, 01:59 PM
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 ?
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 ?