 |
 | 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 / New Users / December 2007vanishing buttons
Hi to All, I used the Tools > Customize command to create some custom button buttons which I placed on an existing toolbar and assigned macros to. After closing Excel and reopening the buttons vanish every time. Why are they volatile and how can I make them permanent? Thanks for your help, Cheers, RonW. toolbars>attach  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hi to All, > [quoted text clipped - 8 lines] > > RonW. Toolbar and menu customozations are saved in a file named Excelxx.XLB where xx is your version of Excel. Usually will be located at...................... C:\Documents and Settings\username\Application Data\Microsoft\Excel Maybe you don't have permission to save to that folder or the folder in which is may be stored if not that one. Have a look for *.xlb file using Windows file search. See where it is and note the size and date. Make some changes in Excel to a Toolbar, close Excel and see what happens to your *.xlb file. Gord Dibben MS Excel MVP >Hi to All, > [quoted text clipped - 8 lines] > >RonW. Thank you Gord, I made sure that Excel11.xlb was open this time before setting up my custom macro buttons, saved everything, closed excel then reopened again and Presto! my new custom buttons now remain alive and well! I deleted the standard Excel shortcut and made a new one like this: Target: "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" Excel11.xlb Start in: "C:\Documents and Settings\Ronald\Application Data\Microsoft \Excel\" Using the above to start Excel is working just fine . . . Cheers and Beers RonW > Toolbar and menu customozations are saved in a file named Excelxx.XLB where xx > is your version of Excel. [quoted text clipped - 27 lines] > > >RonW. Thanks for the update Ron. Something wrong however. The excel11.xlb should open whenever Excel is started and should not need coaxing via shortcut. Gord >Thank you Gord, > [quoted text clipped - 48 lines] >> >> >RonW.
|
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.