Computing.Net > Forums > Office Software > unable to right click in Excel 2007

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

unable to right click in Excel 2007

Reply to Message Icon

Name: rnesbit
Date: July 22, 2009 at 18:47:59 Pacific
OS: Windows EP Pro vr 202 sp3
Product: Microsoft Excel 2007
Subcategory: Microsoft Office
Comment:

I am not able to right click in Excel 2007. When I do so, nothing happens. I can right click in other programs including Word 2007



Sponsored Link
Ads by Google

Response Number 1
Name: jgalty
Date: July 22, 2009 at 20:21:49 Pacific
Reply:

Did you by chance install and excel add-in like essbase if so do the following.
* Go to the Essbase menu and choose Options....
* Click on the global tab
* Uncheck the "enable secondary button" under the "mouse actions" section

If not then try this solution below.


First open Excel and hit "Alt + F11" This will bring up the VBEditor.

From the Menu select Insert -> Module and then copy the following 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

Then hit F5 (or select run from the menu)

Close the VBEditor.

Should work fine now.

Barrie Web Hosting and Web Design Barrie


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: unable to right click in Excel 2007

Unable to right click in IE 5.5 www.computing.net/answers/office/unable-to-right-click-in-ie-55/173.html

Drag point in Excel 2007 www.computing.net/answers/office/drag-point-in-excel-2007/7523.html

Click to add points in Excel www.computing.net/answers/office/click-to-add-points-in-excel/9153.html