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?
|