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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
>
>
>