Everyone,
Below is some code that I've written to add a new right-click shortcut menu item that opens a file based on the data in the active cell. My goal is to have this right click functionality available on any sheet in any workbook without needing the user to add the code to each workbook. Here's the code from personal.xls that adds the right click functionality (emphasis added):
The problem is that the rightclick code above isn't really what's being run and I'm really confused by that. I had changed the "temporary:=True" above to false, and saved everything as an addin (.xla file) to see if it would easily port to other machines. My memory of the exact sequence of events is hazy, so I can't give an accurate timeline of what I did when. I think that when I mucked around with the temporary true/false setting, it got applied to some other persistent location that I can't find. My symptoms are as follows: any changes to the rightclick code above do not affect the project (I can change caption:= to "Change change change" and the rightclick menu item still has the caption "Open in AutoVue"), removing the personal.xls file from the XLSTART folder does not remove the rightclick menu item, and removing the .xla file from the ...Microsoft\Addins folder doesn't get rid of it either.Please Login or Register to view this content.
I'm happy that the code works with any new workbook I open in excel, but I'm unhappy that I've created some sort of immovable object that can't be changed or removed. I need to understand how the menu item got there and what I can do to remove/modify it so that I can figure out the correct method to give the code to other users on other machines. If anyone can offer some suggestions, advice, or other places to look for help, I'd be eternally grateful!
Thanks,
Adam Hartman
Bookmarks