Excel Edit Delete Disabled: How to Re-Enable them!

---

Problem:

While working on Excel, the Delete Row or Column Menu Option is disabled (in both right clicking on the Mouse and in the Menu Bar).

Cause:

This problem usualy is generated for two reassons:
      1. Windows Update
      2. Installation of a Program

Techinical Bug:

     This is a bug in the ListObject code. The problem occurs when 2 or
     more ListObjects are present on the  sheet. They do not enable the
     command bars correctly causing this issue.

Solution:

     A). Simple Profile User Solution (By using this method the user will
           loose any customization to their Computer Desktop and
           Manually Added Drivers).

          1. Sign on as a different user (Power user).
          2. Update windows (if needed)
          3. Reset User profile by right clicking on My Computer and
              selecting the Properties Option

                    

         

          4. Go to The "Advanced Tab" and Click on the "Setting Button"
              in the User Profiles section (Middle Section)

                     

          5. Select the desire User Profile file and copy it to your
             desktop (just to have a backup) and Click on the
             "Delete Button" and confirm.

                   

          6. Log off and then log back on with the Original User Credentials.

     B). Excel Solution 1.  

          1. Close Excel
          2. Locate the file Application Data \ Microsoft Excel \ Excel11.xlb
              and delete the file
          3. Re-Open Excel and validate functionality 

Source:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6dff9cb8-b556-4bbf-aed4-123a7a0c74af

     C). Excel Solution 2.

          1. Open any workbook in Excel
          2. Add the following code to it in VBA.

               Sub ResetBars()
                  Dim bars As CommandBars
                  Set bars = Me.Application.CommandBars
                  For i = 1 To bars.Count
                        Dim bar As CommandBar
                        Set bar = bars(i)
                        bar.Reset
                 Next i
               End Sub
           3. Execute the code you just typed (or copied)

Source:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/6dff9cb8-b556-4bbf-aed4-123a7a0c74af

---