R
Richard
I have a workbook where some cells are protected and others
are unprotected. Sometimes other users move data in
unprotected cells, which messes up formulaes elsewhere in
the workbook. I want users to be able to enter, edit and
copy data, but not move it. Does anyone know if (1) this
sort of protection can be set up through the Tools
Protection menu, and if (b) I can use a VBA macro to set up
this sort of protection whenever the worksheet is
activated?
Richard
are unprotected. Sometimes other users move data in
unprotected cells, which messes up formulaes elsewhere in
the workbook. I want users to be able to enter, edit and
copy data, but not move it. Does anyone know if (1) this
sort of protection can be set up through the Tools
Protection menu, and if (b) I can use a VBA macro to set up
this sort of protection whenever the worksheet is
activated?
Richard