+ Reply to Thread
Results 1 to 5 of 5

How to Disable Right click in sheet tabs in one sheet?

  1. #1
    Registered User
    Join Date
    11-18-2015
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    61

    How to Disable Right click in sheet tabs in one sheet?

    hi,
    Dear Friends,
    I use this code to hide sheet tab .

    Please Login or Register  to view this content.

    Is there a code Just disable right click on one sheet.
    Last edited by alansidman; 05-06-2016 at 11:32 AM. Reason: Applied code tags

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: How to Disable Right click in sheet tabs in one sheet?

    Look at this link

    http://www.learnexcelmacro.com/wp/20...k-excel-macro/


    Also, please review forum rules and use code tags when posting VBA code.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-18-2015
    Location
    qatar
    MS-Off Ver
    2010
    Posts
    61

    Re: How to Disable Right click in sheet tabs in one sheet?

    Thank you
    i see link That you have introduced But did not answer my question.

    I want to code can not be right click on sheet1 in sheet tab.

    I want to know Such a possibility exists.

  4. #4
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: How to Disable Right click in sheet tabs in one sheet?

    Did you follow the first link Alan posted? Its a simple How to on exactly what you are asking.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,937

    Re: How to Disable Right click in sheet tabs in one sheet?

    In case you could not open the page in question, here is a picture of same:
    Capture.PNG

+ 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] How to Disable Cell Merging on Single Sheet (without using sheet protection)
    By nuttyengineer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2016, 07:56 PM
  2. [SOLVED] disable right click on sheet delete/insert sheet in excel
    By rana19 in forum Excel General
    Replies: 7
    Last Post: 10-08-2015, 05:16 AM
  3. Disable Right Click for Macro Button in excel sheet
    By gorkikumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2013, 08:08 AM
  4. 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
  5. Disable sheet tabs right click for current file only
    By ajaykgarg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2010, 03:14 AM
  6. Activate Sheet and Disable Tabs on Open
    By ramakavin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2008, 04:12 PM
  7. [SOLVED] Disable "Sheet tabs" check box under [Tools][Options]-[View] tab
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-01-2005, 11: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