Right Click Insert Row Command Disabled

  • Operating System: 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.



    This has been cross posted from MrExcel Forum: http://www.mrexcel.com/forum/showthread.php?t=525344

  • Re: Right Click Insert Row Command Disabled


    If you are right clicking the row numbers, rather than a subset of cells then the menu is the Row popup, not the Cell one.

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

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Re: Right Click Insert Row Command Disabled


    Not sure why that didn't work, but I added the "ROW" designation to this command and it worked fine.


    Code
    Public Sub Menu_Reset()
    CommandBars("row").Reset
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!