Can you Import & Export toolbars...?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Ive often lost mine, after system restore etc.
I can export the Module with the macros, then re-import
at a later date. But the Toolbar & buttons need to be
re-created and Macros re-assigned.

Thanks for any Help.
Andrew
 
Your toolbar customizations are stored in a file with the extension .XLB.
There may be multiple versions of it. Try to open the .XLB file (with the
most recent datestamp) in Excel and see if you can recover your custom
toolbars.
 
I create a new toolbar and make the edits that I want. Then I save the
toolbars to a workbook for backup. To save to a workbook create your
toolbar(s) and then click on Tools|Customize|Attach...|highlight the toolbars
you want to attach to workbook|Copy>>|then click ok. SAVE WORKBOOK.

Hope this helps - JB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top