Unprotect worksheet being asked when workbook is opened

[kevanr]

Hi, I have multiple sheets that are protected for using the standard Protect Sheet (select locked cells and select unlocked cells both ticked) but when the workbook is opened it prompts the user to provide the password to unprotect for as many instances that there are locked sheets in the workbook.

How do I retain the protection so that selected cells cannot be altered but the password is not called for when the workbook is opened?

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
Do you have a workbook_Open event in that workbook?

 

[kevanr]

Hi Fluff - thanks for the welcome and your response

No, not that I am aware of. The workbook has been saved and is closed. As soon as I select it to open it the Unprotect Sheet password is requested

 

[Fluff]

Have a look in the "ThisWorbook" module of that workbook & see if there is any code there.
Also search the all workbook modules for anything that has Autpen

 

[kevanr]

Have a look in the "ThisWorbook" module of that workbook & see if there is any code there.
Also search the all workbook modules for anything that has Autpen

Thanks Fluff I found it and fixed it - much appreciated !!!

 

[Fluff]

You're welcome & thanks for the feedback