+ Reply to Thread
Results 1 to 9 of 9

Right mouse click doesn't work

  1. #1
    Shopper
    Guest

    Right mouse click doesn't work

    I have the strangest problem... somehow, right clicking a cell doesn't
    bring up a menu anymore. It happens only when I'm in Excel only... it still
    works even if I bring up macro editor within Excel... it only doesn't work
    when I'm in Excel. I've tried Options and Customize... nothing there seems
    to work...
    HELP!!!



  2. #2
    JulieD
    Guest

    Re: Right mouse click doesn't work

    Hi

    is it in every excel workbook or only one ... as code can be written against
    the Worksheet_BeforeRightClick event ... but unless this code has somehow
    gotten into your default template (book.xlt) i can't see how it would affect
    all sheets and workbooks.

    maybe something worth investigating - to see if it is the culprit, open a
    workbook, press ALT & F11 to get into the VBE window, in the project
    explorer (LHS of screen - or choose view / project explorer) double click on
    where it says SHEET1 under your workbook and see if there's any code in
    there for the Worksheet_BeforeRightClick event

    Cheers
    JulieD


    "Shopper" <goshopping@rogers.com> wrote in message
    news:CLOdnczkNfzjoN_fRVn-hg@rogers.com...
    >I have the strangest problem... somehow, right clicking a cell doesn't
    > bring up a menu anymore. It happens only when I'm in Excel only... it
    > still
    > works even if I bring up macro editor within Excel... it only doesn't work
    > when I'm in Excel. I've tried Options and Customize... nothing there
    > seems
    > to work...
    > HELP!!!
    >
    >




  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,291

    Smile

    Good morning Shopper

    I too have had this problem on XL2000 running with WinXP Pro. Strangley enough the right click would work in Word, Powerpoint, other non Office programs and the Windows desktop. It turned out to be a corrupt file in my profile. As it was a work machine, IT managed to find a brand new machine and copy a blank profile over my corrupted dodgy one. If your is a home installation the only solution might be to reinstall?

    HTH

    DominicB

  4. #4
    Dave Peterson
    Guest

    Re: Right mouse click doesn't work

    Try this:
    Open excel
    hit alt-f11 to get to the VBE
    hit ctrl-g to see the immediate window

    Type this and hit enter:
    application.CommandBars("Cell").Reset
    then the same with this line:
    application.CommandBars("cell").Enabled = True

    Hit alt-f11 to get back to excel and test it out.

    Shopper wrote:
    >
    > I have the strangest problem... somehow, right clicking a cell doesn't
    > bring up a menu anymore. It happens only when I'm in Excel only... it still
    > works even if I bring up macro editor within Excel... it only doesn't work
    > when I'm in Excel. I've tried Options and Customize... nothing there seems
    > to work...
    > HELP!!!


    --

    Dave Peterson

  5. #5
    Shopper
    Guest

    Re: Right mouse click doesn't work

    GREAT!!! It worked. Thanks a lot!


    "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
    news:4242B373.DF76008D@netscapeXSPAM.com...
    > Try this:
    > Open excel
    > hit alt-f11 to get to the VBE
    > hit ctrl-g to see the immediate window
    >
    > Type this and hit enter:
    > application.CommandBars("Cell").Reset
    > then the same with this line:
    > application.CommandBars("cell").Enabled = True
    >
    > Hit alt-f11 to get back to excel and test it out.
    >
    > Shopper wrote:
    > >
    > > I have the strangest problem... somehow, right clicking a cell doesn't
    > > bring up a menu anymore. It happens only when I'm in Excel only... it

    still
    > > works even if I bring up macro editor within Excel... it only doesn't

    work
    > > when I'm in Excel. I've tried Options and Customize... nothing there

    seems
    > > to work...
    > > HELP!!!

    >
    > --
    >
    > Dave Peterson




  6. #6
    Registered User
    Join Date
    06-11-2014
    Location
    CASABLANCA
    MS-Off Ver
    2010
    Posts
    3

    Re: Right mouse click doesn't work

    thaks it works

  7. #7
    Registered User
    Join Date
    06-24-2015
    Location
    Calgary, Alberta
    MS-Off Ver
    2013
    Posts
    1

    Re: Right mouse click doesn't work

    I've tried the code you suggested (application.CommandBars...) but am still having issues. The weird thing is that in the same excel file I can right click in several of the worksheets but I can't in others. Any ideas why that might be?

  8. #8
    Registered User
    Join Date
    06-12-2016
    Location
    INDIA, TAMILNADU
    MS-Off Ver
    MS OFFICE 2010
    Posts
    1

    Re: Right mouse click doesn't work

    Thanks for your suggestions and I solved the problem, Thank you
    FRANKO

  9. #9
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office XP to Office 2016
    Posts
    1,173

    Re: Right mouse click doesn't work

    Quote Originally Posted by Dave Peterson View Post
    Try this:
    Open excel
    hit alt-f11 to get to the VBE
    hit ctrl-g to see the immediate window

    Type this and hit enter:
    application.CommandBars("Cell").Reset
    then the same with this line:
    application.CommandBars("cell").Enabled = True

    Hit alt-f11 to get back to excel and test it out.



    Dave Peterson
    After more than 12 years. It also helped me. thanks Dave wherever are you.
    Teach me Excel VBA

+ 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