+ Reply to Thread
Results 1 to 3 of 3

EXCEL VBA to disable right click on BUTTONS.

  1. #1
    Registered User
    Join Date
    03-01-2018
    Location
    Philippines
    MS-Off Ver
    2003,2007,2010,2013 and 2016
    Posts
    51

    Question EXCEL VBA to disable right click on BUTTONS.

    Can anybody help me about disabling the right click function on buttons or command buttons? I really can't find any codes for this. I need to disable the right click on buttons. Thank you.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,720

    Re: EXCEL VBA to disable right click on BUTTONS.

    ActiveX controls don't do anything when you right-click on them unless you are in Developer mode. Forms buttons will bring up a menu but not run the macro. You can suppress this by protecting the sheet.

    What kind of buttons are you using and what you want to prevent people from doing?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-01-2018
    Location
    Philippines
    MS-Off Ver
    2003,2007,2010,2013 and 2016
    Posts
    51

    Re: EXCEL VBA to disable right click on BUTTONS.

    Sorry for a very long period of time to respond to your question. I just need my users not to edit like pasting other data to the file. Thank you so much for the usual help.

    More power.

+ 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. [SOLVED] Right click Copy and Cut is disable (Excel 2013)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2014, 10:19 AM
  2. Replies: 1
    Last Post: 06-16-2013, 12:35 AM
  3. How to disable right click on a button in an excel sheet?
    By Swagata in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2012, 08:22 AM
  4. [SOLVED] Disable ALL Buttons on Button Click in UserForm
    By Nu2Java in forum Excel General
    Replies: 2
    Last Post: 10-05-2012, 02:58 PM
  5. How to disable right-click on the Excel border.
    By taneralan in forum Excel General
    Replies: 3
    Last Post: 08-10-2011, 06:26 PM
  6. Disable border double-click navigation in Excel
    By weatherman in forum Excel General
    Replies: 1
    Last Post: 02-14-2006, 06:10 PM
  7. [SOLVED] How do I disable border double-click navigation in Excel?
    By jeb4nardo in forum Excel General
    Replies: 1
    Last Post: 08-05-2005, 08:05 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