Avatar of Escanaba
Flag for United States of America

asked on 

Excel VB Code Adjust for Worksheet Protect


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.
VB ScriptMicrosoft OfficeMicrosoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon