+ Reply to Thread
Results 1 to 5 of 5

Disabling right click for cut option

  1. #1
    Forum Contributor
    Join Date
    05-10-2016
    Location
    EUROPE
    MS-Off Ver
    Excel 365 64 bitt
    Posts
    178

    Disabling right click for cut option

    Hi,

    I would like to disable only the right click option for cut. I already disable the CTRL+X but users many times accidently right clicks the cell and cut content then the formula in the cell is not functioning as it should.

    Copy past option is ok and that should not be disabled, because users need to use that option.

    Thanks in advance for any help I can get. (Using Excel 2016)
    B.

  2. #2
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,981

    Re: Disabling right click for cut option

    Have you tried
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    05-10-2016
    Location
    EUROPE
    MS-Off Ver
    Excel 365 64 bitt
    Posts
    178

    Re: Disabling right click for cut option

    Hi,

    I tried your code, but I still have the option to cut

    All the best.
    B.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: Disabling right click for cut option

    So, maybe you want to block rightClick?
    Put inside 'ThisWorkbook' code:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  5. #5
    Forum Contributor
    Join Date
    05-10-2016
    Location
    EUROPE
    MS-Off Ver
    Excel 365 64 bitt
    Posts
    178

    Re: Disabling right click for cut option

    Hi,

    Your code works. The problem is that I would like for users to use the rightClick option for copypast values.

    Thanks for helping.
    B.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Disabling copy option
    By vanitarathod in forum Excel General
    Replies: 4
    Last Post: 09-20-2014, 04:26 AM
  2. Disabling right-click on slicer
    By nea in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2014, 06:52 PM
  3. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  4. Replies: 1
    Last Post: 06-02-2006, 04:20 PM
  5. disabling right click
    By Dion in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2005, 06:05 PM
  6. Disabling macros is not an option!!
    By Paul Wagstaff in forum Excel General
    Replies: 5
    Last Post: 05-06-2005, 06:06 PM
  7. [SOLVED] Disabling macros is not an option!
    By Paul Wagstaff in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-06-2005, 01:06 PM

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