Right Click Insert Row Command Disabled

G

gmccreedy

New Member
Joined
Dec 28, 2010
Messages
10
Operating Sustem: Windows XP Professional
MS Office Version: 2010

I have a small issue with two computers in my office that cannot re-enable the "Insert Row" command on the right click menu.

What is strange is the the "insert sheet rows" on the Home-Cells ribbon works fine.

I have tried running the following code to reset the issue, but to no avail.

Code: 
Sub ResetCellMenus()
    Dim cbr As CommandBar
    For Each cbr In Application.CommandBars
        If cbr.Name = "Cell" Then cbr.Reset
    Next cbr
End Sub

Any assistance is greatly appreciated.

For what its worth, the Insert Column Command does work.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
Solved over at OZgrid.

Utilized the following code.
Code: 
Public Sub Menu_Reset()
CommandBars("row").Reset
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Insert merged row into Excel, with duplication of the row(s) formatting above, using Command Button
Replies
1
Views
389
sxhall
S
D
  • Question
Issue when modifying the right click menu
Replies
0
Views
610
DoktorPhill
D
D
  • Question
Issue with EntireRow.Delete
2
Replies
11
Views
798
RoryA
RoryA
F
  • Question
Cell context menu - Sort
Replies
0
Views
464
Formula11
F
A
  • Question
Right Click Function error
Replies
1
Views
478
hajiali
H

Forum statistics

Threads
1,214,920
Messages
6,122,279
Members
449,075
Latest member
staticfluids

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top