ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Lost toolbar (https://www.excelbanter.com/excel-programming/286942-lost-toolbar.html)

Eric S

Lost toolbar
 
OK, I learned the lesson the hard way. Now that I've re-created a lost custom tool bar, is there any way to save a back up copy so if/when it disapears I can get it back without having to re-create all the buttons & assign them again?

Chip Pearson

Lost toolbar
 
Eric,

Search for a file with an xlb extension. Its exact name and
location will depend on your version of Excel and Windows. This
file is where customized menus and command bars are stored. Save
a copy of this file to a safe location. If need be, you can open
this file directly in Excel to restore your command bars.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Eric S" wrote in message
...
OK, I learned the lesson the hard way. Now that I've

re-created a lost custom tool bar, is there any way to save a
back up copy so if/when it disapears I can get it back without
having to re-create all the buttons & assign them again?



Eric S

Lost toolbar
 
Thank You! Now I don't feel so nervous playing with things I don't quite understand yet. Life is safer with a safety net.


All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com