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" <(E-Mail Removed)> wrote in message
newsA5AC674-25DC-48FF-88A9-(E-Mail Removed)...
> 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?