+ Reply to Thread
Results 1 to 3 of 3

Block the cut option

  1. #1
    filo666
    Guest

    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?

  2. #2
    Rocky McKinley
    Guest

    Re: 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" <filo666@discussions.microsoft.com> wrote in message
    news:C372A192-DEBF-421A-B2A3-05AC9C892D2D@microsoft.com...
    > 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?




  3. #3
    filo666
    Guest

    Re: 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" <filo666@discussions.microsoft.com> wrote in message
    > news:C372A192-DEBF-421A-B2A3-05AC9C892D2D@microsoft.com...
    > > 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?

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1