#unprotect

Excel VBA, Working with protected sheets:

This article explains how to  programmatically unprotect your worksheets and workbooks to allow the program to modify and edit your sheets, but still remain protected from the end user: As a VBA programmer you will often have protected sheets where you would like your program to be able to modify but still remain protected from the users. There are different methods for accomplishing this. In the method I will explain a line of code is added to the start of the program which unprotects the sheets and another line of code is added add the end just before program execution ends to protect the sheets again ...