Please review the code in the attached spreadsheet. I am not experienced in VB code and hoping someone can assist. When this code runs it creates new workbooks based on data in column C. Each new workbook is password protected and the worksheets are also protected. I need the code to be updated so for each new workbook the individual worksheets are locked but with no password on the sheet so the end-user can easily unlock for editing.
Greatly appreciate any assistance.