I am working on a permanent custom menu that will be used for a lot of the things that I do on a daily basis. Run reports, open specific workbooks, etc. I want this to be a permanent menu, meaning that it is not tied to a specific workbook. I assume an addin is the easiest way to achieve this, but I'm not sure.
I have most of it completed, but I would like to have a menu entry that deletes/replaces the menu in the event that there are changes made to the menu. This is the part that I can't figure out. The code, as I have it now:
And the ReloadMenu macro:
It's giving me an unknown error, and I'm not sure why. Application-defined or object-defined is the explanation I get. Right now I have this as just an xcel sheet, but I would eventually like to code it as an addin, if I can ever figure out how to do so.
Can anyone help me out with this? The menu is being written for Excel 2003, but I would like it to be as compatible as possible, just in case.