Lost the "right click" cut/copy/paste

[mussermike]

Somehow I lost the right click, cut, copy, paste, special paste. They are still there but "grayed out". The workbook is not protected either. Any thoughts. They are even "grayed out" when I open a brand new sheet.
Help please! Im using excel 2007.

 

[Datsmart]

From the "View" menu select "Immediate Window" if it's not already displayed.
Paste the following statement in the "Immediate Window" and press enter.
Commandbars("Cell").Reset
(Be sure the cursor is on the same line as the statement beforehand)

Did you paste the phrase and then hit "Enter"?

 

[WilliamMR]

I did. I closed Excel, opened it and tried to copy/paste. Nothing has changed. The paste ffeature is still grayed out. Even though I am not that good with Excel, I can't believe I'm screwing something up.

I saw on another forum to do several other things (but I don't like trial & error). I'm ready to do almost anything because this is driving me nuts:
http://www.eggheadcafe.com/software/aspnet/29685542/cannot-rightclick-a-shortcut-menu-in-excel.aspx

 

[xenou]

You might have a an addin installed that's "customizing" your excel menus.

 

[Datsmart]

Is this an issue in just the one workbook or all workbooks you open in Excel?

If it is just this one workbook, what macros do you have in it?
Could you have an "On Open" event macro that is turning OFF the right click menu.

 

[WilliamMR]

This is bad when it's right in front of me. XENOU had the answer. I checked my addins. I haven't touched those in years. So I notice that one of the addins --- obetexcelvbacommon --- is not checked. I don't why, maybe because I saw "vba" in this, but I checked it. All is right with the world.

Thanks for sticking with me on this one. I was at my wits end, and about to hang it up, go to bed, and try again tomorrow. Now I can stay up a few hours and do some work.

Thanks guys. This is a neat forum.

Bill Radwan

 

[rakesh1949]

I am using excel 2010. This solution worked. Thanks

 

[rakesh1949]

I am using excel 2010. This solution worked. Thanks

Well it worked only in the cell but not in the columns or rows .Pl assist in finding a solution. Thanks

 

[gampi1969]

Not certain this will fix it but it should.

Right click on one of the sheet tabs.

Select "View code" from the popup.

From the "View" menu select "Immediate Window" if it's not already displayed.

Paste the following statement in the "Immediate Window" and press enter.

Commandbars("Cell").Reset

(Be sure the cursor is on the same line as the statement beforehand)

You should also be able to reset the "Cell" menu from the GUI. It's not real obvious in 2007 (kinda buried) but help should tell you how.

Gary

Fantastic Gary.. never new this.. thanks a ton and it worked.

 

[ktulsian]

Sir, I had same problem and was able to correct using the command given. However, that was for cells only. How about row and column headings? (I want to cut row and the option is greyed out in context menu) Please provide command to rectify the same.

thanks in advance.

Not certain this will fix it but it should.

Right click on one of the sheet tabs.

Select "View code" from the popup.

From the "View" menu select "Immediate Window" if it's not already displayed.

Paste the following statement in the "Immediate Window" and press enter.

Commandbars("Cell").Reset

(Be sure the cursor is on the same line as the statement beforehand)

You should also be able to reset the "Cell" menu from the GUI. It's not real obvious in 2007 (kinda buried) but help should tell you how.

Gary

 

[Gary McMaster]

You must know the name of the command bar you want to reset if you want to use the original solution: Commandbars("Cell").Reset
where "Cell" is the name of the command bar.

The sample code below will print a list of the built in command bar names in column A of the active worksheet. Put the code in a standard module in a new workbook. If you "uncomment" the indicated line of code it will reset all of the command bars to their original configuration. Resetting everything is probably a bad idea if you have modified a lot of command bars. You could also try resetting some likely candidates based on their name(s) from column A eg Commandbars("Row").Reset or Commandbars("Column").Reset

Public Sub ListCbars()

Dim oCommBar As CommandBar
Dim oCell As Range

Set oCell = ActiveSheet.Range("A1")

For Each oCommBar In ThisWorkbook.Application.CommandBars

    If oCommBar.BuiltIn Then
    
        oCell.Value = oCommBar.Name
        Set oCell = oCell.Offset(1, 0)
        'oCommBar.Reset 'Uncomment this line to reset all built in command bars
    End If
    
Next oCommBar

End Sub