Forum Discussion
HELP stop password prompt from popping up?
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...
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.