Hi Team,
I created a AuditLog sheet to capture the changes in other sheets from same workbook using below code in post2876768 in post#4 but it throws an error 1004 if 'AuditLog' sheet is password protected and it works if it is unprotected. How to unprotect the sheet within the same code and protect it back?
Bookmarks