Reset right mouse click menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LymaBeane - 12 Oct 2006 19:26 GMT

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?

Reply to this Message

CLR - 12 Oct 2006 20:07 GMT

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

> 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.
[quoted text clipped - 14 lines]
>
> What can I do to reset my right mouseclick menu?

Reply to this Message

Ron de Bruin - 12 Oct 2006 20:21 GMT

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)

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>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.
[quoted text clipped - 14 lines]
>
> What can I do to reset my right mouseclick menu?

Reply to this Message