Block the cut option
 

I'm having a lot of problems with the cut-paste options (right click and then
cut) because all the formulas lost his reference; There is a way to block the
cut option or to tell excell when the user uses the cut option excels doesn't
cut also the references?

Block the cut option
 

Place this code in the workbook code module and it will stop all Cut and
Coping.

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

--
Regards,
Rocky McKinley


"filo666" wrote in message
...
I'm having a lot of problems with the cut-paste options (right click and
then
cut) because all the formulas lost his reference; There is a way to block
the
cut option or to tell excell when the user uses the cut option excels
doesn't
cut also the references?

Block the cut option
 

Thanks Rocky, the information given has been helpfully

"Rocky McKinley" wrote:

Place this code in the workbook code module and it will stop all Cut and
Coping.

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

--
Regards,
Rocky McKinley


"filo666" wrote in message
...
I'm having a lot of problems with the cut-paste options (right click and
then
cut) because all the formulas lost his reference; There is a way to block
the
cut option or to tell excell when the user uses the cut option excels
doesn't
cut also the references?