Reset right mouse click menu

[LymaBeane]

I tried to do a macro for copying and pasting formulas. My right mouse
click menu has copy formula and paste formula listed like 6 or 7 times.
The macro didn't work and now I have the multiple "copy formula" and
"paste formula" listed over and over and I can't get rid of it.

I tried the

Sub reset()
Application.CommandBars("Cell").Enabled = True
End Sub

and it didn't work and there was one I put in the immediate window

Application.CommandBars("Cell").Reset

and that didn't work either.

What can I do to reset my right mouseclick menu?

 

[Guest]

Maybe something like this.........you may have to run it several times.....

Private Sub Worksheet_Deactivate()
Application.CommandBars("Cell").Controls("Copy Formula").Delete
End Sub

hth
Vaya con Dios,
Chuck, CABGx3

 

[Ron de Bruin]

Hi

If this is not working
Application.CommandBars("Cell").Reset

Then try this

This is standard reply I use:


Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)