software

I have set up 2 of my own Smarticon bars with a lot of customised icons.
I now have a new pc, how do I transfer them to my new pc?

Thanks

I forgot to say that the version of Office I'm using is Office 2003
Professional (on both PC's)

quot;Chris Gquot; wrote:

gt; I have set up 2 of my own Smarticon bars with a lot of customised icons.
gt; I now have a new pc, how do I transfer them to my new pc?
gt;
gt; Thanks

Chris

Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.

Excel 97.....username.xlb

Excel 2000...Excel9.xlb

Excel 2002...Excel10.xlb

Excel 2003...Excel11.xlb

Note: there may be other customizations you want to transfer at the same time.

Before reading further.......

Transferring your *.xlb file from 97 to 2003 will reduce the functionality
of new version menu items, although most of them can be dragged onto the old
menu.

Read on.........

NOTE: some settings are workbook-specific and would be stored with the
workbook.

For other global stored settings..........

Screen layout, color info, checked Add-ins and many Toolsgt;Options
settings are stored in the Registry, not in the *.XLB file.

To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\E xcel\Options

XX is your version of Excel...8,9,10,11

Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to quot;Registry
editing tipsquot;

www.activewin.com/tips/reg/index.shtml

Export all these keys(as a branch group) to a .REG file so's you can
back them up.

Note also: you may want to move over your *.ACL(autocorrect files) and any
*.DIC files.

For a more comprehensive listing see Dave Peterson's posting at

snipurl.com/8r7xGord Dibben Excel MVPOn Wed, 19 Apr 2006 01:06:01 -0700, Chris G gt;
wrote:

gt;I have set up 2 of my own Smarticon bars with a lot of customised icons.
gt;I now have a new pc, how do I transfer them to my new pc?
gt;
gt;Thanks

Gord Dibben MS Excel MVP

Hi, thanks for the reply

I have done a search for *.xlb on my old pc and no such files exist.
I have managed to solve the problem by quot;attachingquot; the toolbars to my
quot;personal.xlsquot; hidden spreadsheet and copying that accross. The other
settings only take a few minues to change so I'd rather do them manually
rather than edit the registry.

Thanks anywayquot;Gord Dibbenquot; wrote:

gt; Chris
gt;
gt; Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
gt; xxxxxx is version-dependent name.
gt;
gt; Excel 97.....username.xlb
gt;
gt; Excel 2000...Excel9.xlb
gt;
gt; Excel 2002...Excel10.xlb
gt;
gt; Excel 2003...Excel11.xlb
gt;
gt; Note: there may be other customizations you want to transfer at the same time.
gt;
gt; Before reading further.......
gt;
gt; Transferring your *.xlb file from 97 to 2003 will reduce the functionality
gt; of new version menu items, although most of them can be dragged onto the old
gt; menu.
gt;
gt; Read on.........
gt;
gt; NOTE: some settings are workbook-specific and would be stored with the
gt; workbook.
gt;
gt; For other global stored settings..........
gt;
gt; Screen layout, color info, checked Add-ins and many Toolsgt;Options
gt; settings are stored in the Registry, not in the *.XLB file.
gt;
gt; To see some of what's stored in the Registry have a peek at this
gt; section in it, if you feel comfortable.
gt;
gt; HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\E xcel\Options
gt;
gt; XX is your version of Excel...8,9,10,11
gt;
gt; Assuming you are aware of the precautions taken when editing the
gt; Registry and know how to restore a recent backup of same.......
gt;
gt; If not, maybe have a look here first...scroll down to quot;Registry
gt; editing tipsquot;
gt;
gt; www.activewin.com/tips/reg/index.shtml
gt;
gt; Export all these keys(as a branch group) to a .REG file so's you can
gt; back them up.
gt;
gt; Note also: you may want to move over your *.ACL(autocorrect files) and any
gt; *.DIC files.
gt;
gt; For a more comprehensive listing see Dave Peterson's posting at
gt;
gt; snipurl.com/8r7x
gt;
gt;
gt; Gord Dibben Excel MVP
gt;
gt;
gt; On Wed, 19 Apr 2006 01:06:01 -0700, Chris G gt;
gt; wrote:
gt;
gt; gt;I have set up 2 of my own Smarticon bars with a lot of customised icons.
gt; gt;I now have a new pc, how do I transfer them to my new pc?
gt; gt;
gt; gt;Thanks
gt;
gt; Gord Dibben MS Excel MVP
gt;