The project I inherited... when the spreadsheet is in the protected mode, allows general users to input data into unprotected cells and the macro (a sub 'worksheet_change...') calculates fine. When put into 'unprotected mode' (which allows for faster input for some reason) the macro does not calculate properly till a value in a supposed 'protected cell' is changed.
The question is, if the main spreadsheet contains cells that are protected from over-writing, and protection is OFF and the sub (worksheet_change...) references those cells, does the sub only automatically calculate when protection is on, or is this just some VB coding problem.
Hopefully you understand my question...
The question is, if the main spreadsheet contains cells that are protected from over-writing, and protection is OFF and the sub (worksheet_change...) references those cells, does the sub only automatically calculate when protection is on, or is this just some VB coding problem.
Hopefully you understand my question...