How do I transfer excel smarticons from my old pc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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 Tools>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\Excel\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 "Registry
editing tips"

http://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

http://snipurl.com/8r7x


Gord Dibben Excel MVP


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
Click to expand...

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 "attaching" the toolbars to my
"personal.xls" 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 anyway
 
Back
Top