Password Cells Protection

M

Miki

New member
I use Excel’s worksheet password protection to lock cells with formulas so that users do not accidentally delete formulas, I specified a password to let XLS Padlock unprotect and re-protect cells, but the compiled file has an error on the protected cells.
Any advice?
I am using ( Version 2021.1 )
 
False alarm, the error is still there, the cells protected with my password after compiled shows #REF! error.
 
When I don’t set a password, the protection formula works just perfect, the error appear when I set a password, I followed the setps as I specified the password to let XLS Padlock unprotect and re-protect cells. Seems there is not formula issue, maybe is a password unprotect and re-protect problem.
 
Do you think you could share your workbook with us to let us reproduce the problem? Not necessarily the entire workbook, an extract would be enough.
 
You can zip it (with optional password) and upload it to https://wetransfer.com
This is a free and ad-free hosting service: after upload, they will give you a URL. Please send me this URL so I can download the Zip archive.
 
You must log in or register to reply here.
Back
Top