Rightclick is not working in Microsoft Excel 2007

[(Cowherd)]

Sponsored Links

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.

[Erakna]

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.

[AnitG]

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?

[-Deven-]

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.

[BillieJ]

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.

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

[Juurgen]

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