Solved

Reset all Right click Menus in Excel

Posted on 2014-04-01
4
436 Views
Last Modified: 2014-10-07
Experts,

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
Application.CommandBars("Cell").Reset

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.

regards,
JimJam
0
Comment
Question by:ProfessorJimJam
  • 3
4 Comments
 
LVL 5

Expert Comment

by:NARANTHIRAN
ID: 39969057
Try reinstalling the MS office..

hope it helps you..
0
 
LVL 25

Author Comment

by:ProfessorJimJam
ID: 39969224
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 .
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 0 total points
ID: 40358931
i solved this problem by myself. using rightmenu add-in
0
 
LVL 25

Author Closing Comment

by:ProfessorJimJam
ID: 40365539
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is UAC Virtualization in the Process (TASK) Manager? 4 1,163
Slow process to read Excel 15 111
ClickOnce Install - Shortcut Question 3 72
Problem to open text file 11 70
This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget.  The example gadget shows several additional techniques:  How to automatically resize a gadget or flyout panel t…
This article describes how to programmatically preset the "Pages per Sheet" option that's available with most printer drivers.   This setting lets you do "n-Up" printing, where two, four, or more pages are printed on each sheet of paper. If your …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now