Lost custom menus in Excel ?
Lost custom menus in Excel ?
(OP)
Any idea on where (or if) Excel 2002 stores custom menus (not toolbars)?
From another thread y'all can see that loading a commercial spreadsheet blew out a number of my custom menus. Now I have no idea where they are or how to get them back.
I miss the "old" Excel method where they were saved with a specific file.
Thanks for any help.
From another thread y'all can see that loading a commercial spreadsheet blew out a number of my custom menus. Now I have no idea where they are or how to get them back.
I miss the "old" Excel method where they were saved with a specific file.
Thanks for any help.





RE: Lost custom menus in Excel ?
perhaps this webpage is helpful. I know it addresses toolbars and not menus, but . . .
http://of
Good Luck!
-pmover
RE: Lost custom menus in Excel ?
I'm sorry that a website I suggested caused you this problem. I called SEAOC and spoke with Tracy Brown. She suggest that you return to the website and select the software that you downloaded. There is an email link to the author. Perhaps you can get some help from them.
Good Luck.....
RE: Lost custom menus in Excel ?
I was able to restore myself this morning because I had an archived "xlb" file (the Excel menu/toolbar file). I have run into this problem in the past when changing computers, updating Windows, etc. It really points out a vulnerable spot in Excel, that this customization is so easily lost. In older versions of Excel you could create custom menus from within a spreadsheet file. This is not so easily done with new versions of Excel. I would like to learn how to create menus programmatically, it would be ever so much more safe and reliable.
However, I have learnt my lesson this time!
RE: Lost custom menus in Excel ?
This website you may find useful in creating custom menu's.
http://www.ozgrid.com/VBA/custom-menus.htm
Oh!, I Keep a separate text file of all custom written vba code for my toolbars/buttons. That way, when changing computers or otherwise, the code is readily available.
Good Luck!
-pmover