protecting cells from being moved

  • Thread starter Thread starter Pauldad26
  • Start date Start date
P

Pauldad26

Is there any way to allow someone to enter a number in a cell, but
prevent them from moving (drag/drop) it around?

I have a data input worksheet where the user enters a bunch of values
in row/column format. I've got other worksheets that take that data
and do their thing. I want the whole thing protected against changes,
and I know how to protect all the cells except the data entry cells.
Problem is, the user can drag the data entry cells around in the
unprotected area. This actually happens, as someone will type a number
in the wrong cell and then drag it to the "right" one, which of courses
messes up the calculations.
 
Paul,

Drag and drop isn't meant to be a data entry tool, only really a worksheet
entry tool. It can definitely mess up formulas.

The option can be turned off with Tools - Options - Edit - "Allow cell drag
and drop." An event macro could turn if off when the worksheet is opened.
It'll take some management, as it'll need to be turned back on when the
worksheet is closed (or better yet on and off as the window is activated if
the user has other workbooks open and wants to maintain cell drag and drop).

Another option, if your users are tractable enough, is to train them to
instead copy the cells (hold Ctrl as the cell is edge-dragged), then delete
the original.

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
Oops. I didn't say what I meant.

Drag and drop isn't meant to be a data entry tool, only really a worksheet
DESIGN tool. It can definitely mess up formulas.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Earl Kiosterud said:
Paul,

Drag and drop isn't meant to be a data entry tool, only really a worksheet
entry tool. It can definitely mess up formulas.

The option can be turned off with Tools - Options - Edit - "Allow cell drag
and drop." An event macro could turn if off when the worksheet is opened.
It'll take some management, as it'll need to be turned back on when the
worksheet is closed (or better yet on and off as the window is activated if
the user has other workbooks open and wants to maintain cell drag and drop).

Another option, if your users are tractable enough, is to train them to
instead copy the cells (hold Ctrl as the cell is edge-dragged), then delete
the original.

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
Click to expand...
 
Back
Top