 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / October 2006Menu bar won't save
Hi Please help I like to edit the menubar by opening >tools >customize >commands >reorganize I can choose the menu I like to change on top > modify selection >rename the name and close save as long I do not close the program it works fine after closing and startup the program again the menubar has not been saved what do I wrong ?? Thanks in advance for your prompt reply Best regards Ron Ron Menu and Toolbar customizations are stored in your Excelx.xlb file "x" is a version number like 9 for 2000, 10 for 2002 and 11 for 2003. If it gets too large, it can become unstable. Or perhaps if on a network, Excel is confused about where to store it. Or you do not have permission to save to the folder where *.xlb is stored. Do a search for this file. There could be more than one *.xlb file so may have to check all copies to see which is loading. Usually stored in.................. C:\Documents and Settings\username\Application Data\Microsoft\Excel When found, first rename the *.XLB file to *.OLD file. Note the size of this file in kb. Now close out Excel then re-open. Make a few minor changes to a menu or toolbar then close Excel. Does Excel create a new *.XLB file? Is it basically the same size as the *.OLD file? Reopen Excel. Have your changes stuck? Gord Dibben MS Excel MVP >Hi >Please help [quoted text clipped - 18 lines] >Best regards >Ron Gord Dibben MS Excel MVP Hi Gord Thanks for assistance Tried to change the menubar on my computer cannot press the reorganizebutton (grey) Cannot find any XLB file Will do same on my home computer will revert with results Best regards Ron Gord Dibben schreef: > Ron > [quoted text clipped - 54 lines] > > Gord Dibben MS Excel MVP Hi Gord Tried at home now I found the XLB file after deleting it and rerun the program changing the menubar a new XLB has been created and bar is saved I probably mixed up excel 95-97 file with excel 2003programm what happens is the standard menubar2003 appears and the selfmade bar of the 97 file is connected to that standard menubar the standard Helpsection is now missing. When I startup the 97 file I can see the standard Menubar The program asks for enabling/disabling macros I disable the Macros and see the selfmadebar is connected and visible. There must be a code in that particular 97 file that says "show the selfmade bar as well" and do not safe. Any idea ?? Best regards Ron Typical on the computer at work there is no XLB file at all excel2000 thats why I cannot change the menubar. > Hi Gord > [quoted text clipped - 68 lines] > > > > Gord Dibben MS Excel MVP Sounds like your workbook is creating the additions to your Menubar. Tools>Customize>Toolbars>Toolbars in Workbook(right-side)>Attach. Anything there you can unattach? Or do you have Personal.xls opening hidden? It is possible you have a Personal.xls left over from when Excel had a Menu Editor. Items were attached from your Personal.xls. Do a search for XLSTART folder and remove the Personal.xls file to somewhere else so it won't open. Delete or re-name your *.xlb file again. If you can't find what is adding the selfmade bar we can provide some code to remove it permanently if it is a holdover from Excel 95. Gord >Hi Gord > [quoted text clipped - 98 lines] >> > >> > Gord Dibben MS Excel MVP Hi Gord tried all options The XLStart Map contains only exel11.xlb file Think the file is mixed with 95 and 2003 code because all other files work fine do you have a code to remove the menubar ? Regards Ron > Sounds like your workbook is creating the additions to your Menubar. > [quoted text clipped - 121 lines] > >> > > >> > Gord Dibben MS Excel MVP Jim Rech has written an add-in to remove the left-over 95 menus from a workbook. Can be d/l from Stepen Bullen's site. http://www.oaltd.co.uk/MVP/Default.htm Click on Jim Rech or scroll down the page to find RemoveMenus.zip Unzip to your Office\Library. Open Excel and Tools>Add-ins. Find and check. Gord >Hi Gord > [quoted text clipped - 133 lines] >> >> > >> >> > Gord Dibben MS Excel MVP Hi Gord / Jim That will do Thanks Ron Stolk > Jim Rech has written an add-in to remove the left-over 95 menus from a workbook. > [quoted text clipped - 147 lines] > >> >> > > >> >> > Gord Dibben MS Excel MVP Hi Gord / Jim That will do Thanks Ron Stolk > Jim Rech has written an add-in to remove the left-over 95 menus from a workbook. > [quoted text clipped - 147 lines] > >> >> > > >> >> > Gord Dibben MS Excel MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.