Hi Pankaj,
just change your macro to:
This will unprotect the sheet at the beginning of the macro and protect it at the end again.
Additionally I have added a logic to prevent the macro from entering any data into other columns than g and H.
I have entered the macro into your file (and adjusted the protection). If you neeed to change anything, the current password is "YourPassword" (without quotes)
Hope this helps
Theo
________
Please do not forget to close the thread once your issue is solved. Thank those who helped you by clicking the little star to the left of your helpers reply!
Hope this helps
Bookmarks