I made a protected template for my dad and, despite my warnings,
occasionally he moves (cuts and pastes) one of the input cells which screws
up the equations. Is there a way to set it up so he can edit the input
cells but not move them?

Thanks!
Dean

Have you considered spanking?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dean" wrote in message
...
I made a protected template for my dad and, despite my warnings,
occasionally he moves (cuts and pastes) one of the input cells which screws
up the equations. Is there a way to set it up so he can edit the input
cells but not move them?

Thanks!
Dean

He's about 2500 miles away!

"Don Guillett" wrote in message
...
Have you considered spanking?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dean" wrote in message
...
I made a protected template for my dad and, despite my warnings,
occasionally he moves (cuts and pastes) one of the input cells which
screws up the equations. Is there a way to set it up so he can edit the
input cells but not move them?

Thanks!
Dean

"Dean" wrote...
I made a protected template for my dad and, despite my warnings,
occasionally he moves (cuts and pastes) one of the input cells which
screws up the equations. Is there a way to set it up so he can edit the
input cells but not move them?

Try putting the following code into the ThisWorkbook class module of the
workbook.


Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


This will turn off Cut mode when he moves around within the same worksheet,
moves to a different worksheet, or moves to a different workbook.

Perhaps I needed to be more explicit. Actually, my dad doesn't even know
how to cut and paste. But what he does know is how to move by dragging the
contents of a cell with his mouse. I always assumed that such was exactly
the same as cut and paste, but it seems to not be true since your procedure
seems to hush the paste icon, but does not impede clicking and dragging.
Can you help prevent that?

Dean


"Harlan Grove" wrote in message
...
"Dean" wrote...
I made a protected template for my dad and, despite my warnings,
occasionally he moves (cuts and pastes) one of the input cells which
screws up the equations. Is there a way to set it up so he can edit the
input cells but not move them?

Try putting the following code into the ThisWorkbook class module of the
workbook.


Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
If Application.CutCopyMode = xlCut Then Application.CutCopyMode = False
End Sub


This will turn off Cut mode when he moves around within the same
worksheet, moves to a different worksheet, or moves to a different
workbook.

"Dean" wrote...
Perhaps I needed to be more explicit. Actually, my dad doesn't
even know how to cut and paste. But what he does know is how to
move by dragging the contents of a cell with his mouse. . . .
....
Can you help prevent that?

Tools Options, Edit tab, uncheck 'Allow cell drag and drop'.

Silly me - I knew that once!

I assume that then becomes a global EXCEL setting, but can I have this file
uncheck it when he opens the file and recheck it when he exits (or when he
resaves it)?

Dean

"Harlan Grove" wrote in message
ups.com...
"Dean" wrote...
Perhaps I needed to be more explicit. Actually, my dad doesn't
even know how to cut and paste. But what he does know is how to
move by dragging the contents of a cell with his mouse. . . .
...
Can you help prevent that?

Tools Options, Edit tab, uncheck 'Allow cell drag and drop'.

"Dean" wrote...
....
I assume that then becomes a global EXCEL setting, but can I have this file
uncheck it when he opens the file and recheck it when he exits (or when he
resaves it)?
....

Record the method calls involved while performing these operations manually,
then add the unchecking code to the workbook's Open and Activate event
handlers and the checking code to the workbook's BeforeClose and Deactivate
event handlers.