Lost the "right click" cut/copy/paste

G

Gary McMaster

Well-known Member

Joined

Feb 8, 2009

Messages

1,978

• Feb 14, 2010

• #2

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

 

Upvote 0

M

mussermike

New Member

Joined

Jun 25, 2009

Messages

19

• Feb 14, 2010

• #3

Thank you, worked like a charm!

 

Upvote 0

G

Gary McMaster

Well-known Member

Joined

Feb 8, 2009

Messages

1,978

• Feb 14, 2010

• #4

If you didn't knowingly alter that popup menu you probably have an addin or macro that is not putting things back the way it found it (crash also possible). If that is the case, and you can identify the culprit, you might be able put that statement in the workbook close event (or elsewhere) to make sure the menu is always reset to the "factory" configuration when you close the workbook.

Gary

 

Upvote 0

WilliamMR

New Member

Joined

Feb 1, 2011

Messages

5

• Feb 1, 2011

• #5

I'm not sure when this happened to me, but I have the exact same situation. I am using Excel 2003. I tried going to the tab and try the fix, but my tab does not show this when I go to "view code". Help?

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Feb 1, 2011

• #6

Can you open the VBA Editor? (Alt-F11)

If so, follow Gary's steps in his post above.
If you can not open the VBA Editor, please post detailed information of what is occuring.

 

Upvote 0

G

Gary McMaster

Well-known Member

Joined

Feb 8, 2009

Messages

1,978

• Feb 1, 2011

• #7

but my tab does not show this when I go to "view code"

Click to expand...

Does not show what?

Gary

 

Upvote 0

WilliamMR

New Member

Joined

Feb 1, 2011

Messages

5

• Feb 1, 2011

• #8

I get a window which has the following in it already:

"Private Sub Worksheet_SelectionChange(ByVal Target As Range)"
End Sub

Should I get rid of this and then follow your instructions, or add it after the above?

 

Upvote 0

G

Gary McMaster

Well-known Member

Joined

Feb 8, 2009

Messages

1,978

• Feb 1, 2011

• #9

Paste that code snip in the "Immediate" window. It has the word "Immediate" in the title bar. If it is not visible then go to the "View" menu and turn it on by selecting it.

Gary

 

Upvote 0

WilliamMR

New Member

Joined

Feb 1, 2011

Messages

5

• Feb 1, 2011

• #10

Obviously I have never ventured in this area of Excel. I cut & pasted the statement, then closed it and went back to look at it again. There must be a plan B, because it still doesn't work. Here is what showed up in the "Immediate" window:

[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs] >
[PickPlatform] <
[PickPlatform] >
[VerifyOpen] <
[VerifyOpen] > 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs] >
[auto_open] >

 

Upvote 0