View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default 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?