I have the following issue: When right clicking in a row or column in Excel 2010 no menu is appearing. In Excel 2003 right clicking in a row lets you insert/delete rows.
Do you know if this functionality does not exist in Excel 2010 or if my Excel installation is problematic and what I need to do to resolve this?
Update: I am using Windows 7 64 bit and my Office is the Home and Business Edition.
25 Answers
Hit Alt+F11 to get to the VBE. Hit Ctrl+G to see the immediate window.
Enter the following
application.CommandBars("Cell").Reset
application.CommandBars("cell").Enabled = True
application.CommandBars("Column").Reset
application.CommandBars("column").Enabled = True
application.CommandBars("Row").Reset
application.CommandBars("row").Enabled = TrueAlt+F11 to return to Excel.
Start Excel in safe mode and see if the problem persists. It may be an add-in that is stealing the functionality.
To open Excel in safe mode, find an Excel document, and hold down Ctrl when double-clicking on it. You should be prompted to open in Safe Mode.
EDIT: There's a VBA macro you can use from this site, which will apparently restore right-click behaviour:
Sub SwitchOnCutAndPaste()
EnableControl 21, True
EnableControl 19, True
EnableControl 22, True
EnableControl 755, True
End Sub
Sub EnableControl(Id As Integer, Enable As Boolean)
Dim CB As CommandBar
Dim CBC As CommandBarControl
For Each CB In Application.CommandBars Set CBC = CB.FindControl(Id:=Id, recursive:=True) If Not CBC Is Nothing Then CBC.Enabled = Enable
Next
End SubThis worked for me:
Hit Alt+F11 to get to the Visual Basic Editor, hit Ctrl+G to see the immediate window, and enter the following:
Application.CommandBars("cell").Enabled = True
Application.CommandBars("Ply").Enabled = True
Application.CommandBars("row").Enabled = True
Application.CommandBars("column").Enabled = TrueAlt+F11 to return to Excel.
"ply" is the code used to enable right click of worksheet tabs.
It is the windows profile issue - log in as administrator rename old profile as .old and log in as user to recreate the new windows profile fix the problem.
1For a complete fix across cell, row, column, tab I needed a composite of this:
application.CommandBars("Cell").Reset
application.CommandBars("cell").Enabled = True
application.CommandBars("Column").Reset
application.CommandBars("column").Enabled = True
application.CommandBars("Row").Reset
application.CommandBars("row").Enabled = True
Application.CommandBars("Ply").Reset
Application.CommandBars("ply").Enabled = True
