Right click menu - how to reset?

[MegWump]

Hi,
I've had a workbook customised for me by someone who can do vba and some coding.

The workbook involved a lot of ribbon customisation, but also included customising the menu that appears when you right click. Unfortunately, this menu is appearing on all my excel workbooks (despite that workbook that should have it not having been used for several days, so it's not about an open instance of excel) and it means I can't do a lot of the simple tasks I'm used to.

Can anyone walk me through how to reset it to the default?

I know how to turn on the developer tab and that's about it!

 

[oldbrewer]

could you move a copy of the workbook to an external hard drive, then delete it from your working drive ?

 

[RoryA]

There are several right-click menus. On the assumption you are talking about the Cell menu, open the VB Editor (Alt+f11), then the Immediate Window (Ctrl+G), type:

Application.Commandbars("Cell").Reset

and press enter.

 

[MegWump]

There are several right-click menus. On the assumption you are talking about the Cell menu, open the VB Editor (Alt+f11), then the Immediate Window (Ctrl+G), type:

Application.Commandbars("Cell").Reset

and press enter.

Belated thanks for this – It worked and I appreciate it

 

[RoryA]

You're welcome - glad it helped.

 

[imin2science]

Many thanks to RoryA for that suggestion. Two years and nine months after your reply to MegWump, this tip was of tremendous help to me.

The only difference is that my Rightclick Cell Menu problem was self-inflicted. This has been a lesson learned, the easy way, thanks to you.

 

[cnan]

Hi,
what about the horizontal right-click mouse menu.
Mine has vanished...

 

[RoryA]

Use this in the immediate window:

application.ShowMenuFloaties = false

Note that the values are completely counterintuitive!

 

[Artik]

... Or from the ribbon: File/Options/General tab, check the box "Show Mini Toolbar on selection".

Artik