Protect cells from moving

N

Neil Rothbart

I have a protected worksheet with unprotected cells for users to input
data.

There are formulae which read the cells to build up a set of codes.

Users have been moving thier input cells (Cut & Paste) which of course
corrupts the formulae.

Protection allows me to prevent inserting and deletion of rows but not
cells.

How can I prevent users from moving cells. Its fine if they want to
copy. So Copy & Paste is fine but not Cut & Paste.

Thanks

Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
I copied Visible Cells Only, but it pastes only the first cell 1
Possible to select a string in a locked cell? 1
protect borders on a data entry cell 1
Protection from cut and paste 6
making cells uncopyable 1
Synchronization problems while moving folders to new email 1
Changing Cell Colour in Protected Sheet 1

Top