Results 1 to 6 of 6

Thread: Rightclick is not working in Microsoft Excel 2007

  1. #1
    Join Date
    Jan 2012
    Posts
    27

    Rightclick is not working in Microsoft Excel 2007

    Is there a feature that switches Right-Clicking on and off. Right-Click has suddenly stopped working in Excel 07 although works fine in other Office 07 programs. How do I get it to operate again.

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    Re: Rightclick is not working in Microsoft Excel 2007

    You might rename or delete your Excel 2007 toolbar file Excel12.xlb found here (with Excel closed): C:\Documents and Settings\<user name>\Application Data\Microsoft\Excel.

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: Rightclick is not working in Microsoft Excel 2007

    One thing occurred to me yet. Our IT man told me that Office 2007 (trial version) installed next to the first Excel 2003. Then uninstall and on it given the purchased version. Whether it has something to do, I can not say. I searched the Internet and found the following:
    CommandBars ("Ply"). Enabled = True
    Application.CommandBars ("Ply"). Enabled = True

    These commands will work again with the right mouse button. But when I start each entry must be the macro. Have ye here any idea how to do that again can be produced without macro again. Or if that does not work, you can automatically run the macro with the Excel startup?

  4. #4
    Join Date
    Aug 2011
    Posts
    460

    Re: Rightclick is not working in Microsoft Excel 2007

    This is actually normal because when spreadsheet changes the settings are changed for any Excel. If you put in manual calculation mode, this remains true until it is automatic, for example. So we must identify the workbook that makes the change and ensure to go through the recovery process.Excuse me again, but how to access the VBA code to see the changes that were made.

  5. #5
    Join Date
    Jul 2011
    Posts
    440

    Re: Rightclick is not working in Microsoft Excel 2007

    This can be fixed via vbeditor. Open Excel and perss Alt + F11. Click on Menu > Insert > Module. Add the below code and then hit F5.
    Code:
    Sub Enable_All_Right_Click_Menus()
    'This will enable all BuiltIn Command bars
    Dim Cbar As CommandBar
    For Each Cbar In Application.CommandBars
    Cbar.Enabled = True
    Next
    End Sub

  6. #6
    Join Date
    Mar 2012
    Posts
    1

    Re: Rightclick is not working in Microsoft Excel 2007

    One of my users got this problem today and BillieJ solution solved the case

Similar Threads

  1. How to open UTF-8 in Microsoft Excel 2007
    By Kaesav in forum MS Office Support
    Replies: 2
    Last Post: 10-02-2012, 05:19 PM
  2. F2 key is not working in Microsoft Excel 2007
    By ELETTRA| in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 05:59 PM
  3. Autofit Row height is not working in Microsoft Excel 2007
    By SadyQ in forum MS Office Support
    Replies: 4
    Last Post: 24-01-2012, 12:55 PM
  4. Microsoft Excel 2007 formatting
    By Meditation in forum Windows Software
    Replies: 4
    Last Post: 29-01-2011, 04:58 PM
  5. Benefits of using Microsoft Excel 2007
    By XDRoX in forum Tips & Tweaks
    Replies: 1
    Last Post: 06-04-2009, 05:24 PM

Tags for this Thread

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
  •  
Page generated in 1,711,619,169.79820 seconds with 17 queries