rajagopal
10-31-2008, 12:35 AM
When the user updates data in column F in a cell range, he has to compulsorily update the target date (Column H) in the corresponding cell range also.
Say, If the user updates data in cell F7 and not updated the target date in cell H7 and closes the file, an alert message has to pop-up (Ok). If the user click OK, the close book event has to be disabled.
I attached the sheet.
Raj
Say, If the user updates data in cell F7 and not updated the target date in cell H7 and closes the file, an alert message has to pop-up (Ok). If the user click OK, the close book event has to be disabled.
I attached the sheet.
Raj