ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you Import & Export toolbars...? (https://www.excelbanter.com/excel-programming/331552-can-you-import-export-toolbars.html)

Andrew

Can you Import & Export toolbars...?
 
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



Vasant Nanavati

Can you Import & Export toolbars...?
 
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.

--

Vasant


"Andrew" <NoToSPAM@home wrote in message
...
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





Jody B

Can you Import & Export 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

"Andrew" wrote:

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





All times are GMT +1. The time now is 02:35 AM.

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