is there a way to disable the ability for a user of my app to select a cell
where the cursor changes to a 4 arrow and the cell can be moved to another
location. the macro recorder called it selection.cut and selection.paste.
is there a way to disable this globally across the entire sheet?

Private Sub Workbook_Activate()
Application.CellDragAndDrop = False
End Sub

in case anyone searches.

"Spencer" wrote:

is there a way to disable the ability for a user of my app to select a cell
where the cursor changes to a 4 arrow and the cell can be moved to another
location. the macro recorder called it selection.cut and selection.paste.
is there a way to disable this globally across the entire sheet?

Spencer,
Note that this will disable the ability the fill down/across.

NickHK

"Spencer" wrote in message
...
is there a way to disable the ability for a user of my app to select a
cell
where the cursor changes to a 4 arrow and the cell can be moved to another
location. the macro recorder called it selection.cut and selection.paste.
is there a way to disable this globally across the entire sheet?