HELP stop password prompt from popping up?

Visitor

Hi, I have a workbook that will be shared with over 100 people. I don't want anyone changing the cells or formulas so protected each tab and I set a password on them (previously I distributed it with no password and a bunch of people messed with the formulas). 

 

My issue is that now every time I open the file, a prompt pops up asking me to enter the password. I have to click cancel once for each tab that has a password (11 total). 

ExcelNewbie617_0-1656600946017.png

Is there ANY way to get this to stop popping up? The people I will be sending this to are not very excel savvy and I worry they wont understand what to do (plus it's just annoying). 

 

To be clear, I am not clicking "unprotect" to make this pop up, it just happens whenever I open the file. Any help greatly appreciated! 

 

 

3 Replies
I was waiting to see if anyone else had any ideas but noone else answered yet so here is my 2 cents:
It shouldn't be doing this. I couldn't get this behavior to happen. Is this a macro-enabled worksheet (.xlsm or .xlsb)? Do you have an example without confidential/private/personal info you can share that is doing this?
I assume some VBA code runs when the file is opened which tries to unprotect the sheets, but the unprotect method is not provided with the password. If you add the password as an argument to the unprotect statement(s), Excel will stop asking for the passwords.

@ExcelNewbie617 

Try unlocking the worksheet...here are some links to do it yourself.

1 Link:Password Options

2 Link:How to unprotect the excel sheet if forgot the password