How can I import custom toolbars from Excel 10 to Excel 11 same in
PowerPoint. Renaming preference files Š toolbars (10) > Štoolbars (11)
won¹t work.
One way
In v.X, attach the toolbar to a workbook (Tools/Customize/Toolbars click
Attach and copy your bar(s) to the workbook.
Open the workbook in XL04, the close XL. The toolbar will be saved in
Toolbars (11).
Note: Toolbar formats change - don't be surprised if you have to replace
a toolbar icon. Also, there's no guarantee that control ID's for the
commands on your toolbars will be the same in XLv.X and XL04, so you may
need to customize the toolbar in XL04.
Rather than relying on the Toolbars (nn) preference, I recommend
attaching (or, using VBA, creating) toolbars in a file/add-in that you
can put in your Microsoft Office 2004:Office:Startup:Excel folder. That
way you can trash your preferences and preserve your toolbars (I also
use VBA to set preferences, add custom lists, etc.).
I've been working on a web page for customizing XL using add-ins, but
you can find additional resources for creating toolbars in VBA, such as
the MSKB article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;830502
