Hi,
I'm aware that if you cut & paste cells that are referenced by formulae in other cells, the formulae references themselves are automatically updated. This is true even if the cells containing the formula are 'locked' and worksheet itself is protected. [The cells being cut/pasted are not locked - probably because they are 'data input' cells].
I normally protect against this eventuality by including a little VBA code to disable 'cutting' of cells, and requiring users to 'copy', 'paste' and 'delete' if they want to effectively achieve a 'cut and paste' functionality.
But this solution requires making all my workbooks macra-enabled.
Is there an equally secure/safe method of protecting the integrity of my cell formula without making my workbooks macro-enabled?
Thanks in anticipation for any good solutions. I have searched the web extensively.
MathUKTeacher
Bookmarks