+ Reply to Thread
Results 1 to 18 of 18

how to enable right mouse click on the tab

  1. #1
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    how to enable right mouse click on the tab

    my right mouse click is not working on the Excel tab...

    please suggest a VBA code to enable it.

    Thanks

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: how to enable right mouse click on the tab

    Try :

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    Nope, it didn't work... sample is here

    https://drive.google.com/file/d/1G0V...usp=drive_link


    thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: how to enable right mouse click on the tab

    Why are you attaching a GoogleSheet? Please attach the Excel woprkbook directly here using our attachment facility.

    Which version fo Excel are you usi g? Your forum profie needs to state this.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    portal doesn't give me the option to attach file... here is what I see:

    Attachment 860006

    I uploaded the file to google drive, but it's the excel sample not the google doc

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: how to enable right mouse click on the tab

    Bottom right - click Go Advanced - scroll down to Manage Attachments. I wouldn't ask you to do something that wasn't possible, and it's all explained in the yellow banner at the top of this page.

  7. #7
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    Book1- del it.xlsm

    File is attached

    my excel version is Office 365

    Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: how to enable right mouse click on the tab

    Thanks - that needs to go into your forum profile, please.

    Thanks for attaching the workbook.
    Attached Images Attached Images

  9. #9
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    done... thanks

  10. #10
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: how to enable right mouse click on the tab

    The macro works here.

    See attached.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    yes, your macro worked in your file... thanks for that

    Q1. it's not working in my file... I am sure doing something wrong here

    Attachment 860054

    Q2. why is it not working by default... I even removed office 365 from my device and reinstalled it.

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

    Re: how to enable right mouse click on the tab

    This appears to be the same question you posted here

    https://www.excelforum.com/excel-gen...-properly.html

    Please explain the difference or I am going to close this one as a duplicate.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  13. #13
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: how to enable right mouse click on the tab

    My first action would be to uninstall Excel ... reboot computer ... reinstall Excel.

    Since the copy I sent you works here ... Excel corruption is my first suspect.

  14. #14
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    the one posted here is just a subset (right mouse click on tab issue). the other one is more than that

  15. #15
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    I've done this part... fix, repair, uninstall/reinstall... tried all of it but it's the same

  16. #16
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    Please advise how to put it into the code ... I am getting the following error


    Screenshot 2024-02-18 144006.png

  17. #17
    Registered User
    Join Date
    01-02-2024
    Location
    USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    23

    Re: how to enable right mouse click on the tab

    please advise

  18. #18
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: how to enable right mouse click on the tab

    On the MENU BAR select INSERT / MODULE.

    In the new module paste the macro :

    Please Login or Register  to view this content.
    Then go out to the worksheets, create a COMMAND BUTTON to paste on the worksheet. Select the macro name 'tester', then click OK.

    Click button to run the macro.

+ 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. Is there a way to enable macros without using a mouse?
    By kristenhayes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2013, 10:09 PM
  2. Replies: 0
    Last Post: 03-06-2013, 12:52 PM
  3. Prevent ListBox Click Event Until Mouse Click
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2011, 12:23 PM
  4. vba code for moving the cursor/right click/left click of the mouse?
    By yellowpower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2010, 10:07 AM
  5. How to Act on a Mouse Click
    By dhatul in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2010, 01:24 AM
  6. Enable Mouse's right button Menue & WS editing while Userform running
    By wali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2009, 08:20 AM
  7. right mouse click and IF...Then
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2005, 03:15 PM
  8. Each Click of the Mouse
    By D.Parker in forum Excel General
    Replies: 14
    Last Post: 04-28-2005, 07: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