I have a worksheet_change event that only fires when the sheet is unprotected. I need to unprotect the sheet, run the code, then reprotect the sheet. The event should trigger a message box when the user pastes invalid data into the vertically dynamic range named "ValidationRange," which is in column J. If I unprotect the sheet manually, and remove the protect/unprotect lines in the below code, the event fires. Here is the code which currently doesn't work:
Any help much appreciated,Please Login or Register to view this content.
Best,
Bob
Bookmarks