• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1382
  • Last Modified:

Reset all Right click Menus in Excel


i have a problem,

i have installed an add-in and removed it, it was a beta version, so did not work well. but what it did was that it somehow distorted my right click menu in excel.  the problem is that it is not the right click on a normal cell. when i right click on a normal cell everythign is okay. but when i create a table in excel and when i right click, there are too many customized named in my right click which i cannot get rid of them, when i click on them, it gives me an error that the add-in file is missing etc although add-in file has already been deleted.

i tried searchign the web and all i could find is the vba code

Open in new window

 this only works for normal right click menu and but this does not restore to default the right click menu on table cell.

i also found another code
Application.CommandBars("Cell").Controls("name of  control).Delete

Open in new window

 but then this does not work , becuase there are too many of them and i do not know all of the original names of the customized right click menu on the table cell.    i was looking for help if someone could have a code that would reset all the right click menu in cell or in a table or pivot table , just to restore everything to the built-in default right click menus . would greatly appreciate it.

  • 3
1 Solution
Try reinstalling the MS office..

hope it helps you..
ProfessorJimJamAuthor Commented:
Naranthiran,   :-)   i know that already, but i operate in domain user access, cannot install or uninstall software. my question aims for a code to find out a way to reset it with VBA .
ProfessorJimJamAuthor Commented:
i solved this problem by myself. using rightmenu add-in
ProfessorJimJamAuthor Commented:
my question was never answered, so i found an add-in called rightmenu and stated that in this thread, so that it may benifit others.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now