Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import & Export | Excel Discussion (Misc queries) | |||
Import/Export | Excel Discussion (Misc queries) | |||
Import/Export Cells | Excel Programming | |||
import and export vba | Excel Programming | |||
Import and Export | Excel Programming |