quantum-dan / DeCal

BMP decay parameter calibration tool.
1 stars 1 forks source link

Lock cells that should not be edited #1

Open quantum-dan opened 5 years ago

quantum-dan commented 5 years ago

Solution doesn't seem to be viable due to serious bugs in Excel's sheet protection. Upon protecting the sheet and locking the relevant cells, the sheet can't be un-protected (Excel always claims the password is wrong, even when no password is set) and the cells can't be unlocked even from VBA and even when Protect is specifically called with a parameter to still allow VBA to edit locked cells.

In other words, not happening because Excel.