Just bought a new PC; this one with Win XP and XL 2003. The old one had
Win ME and XL 2002.

Each time, whether for a new PC, or a new installation on an existing
PC, or whatever, I have had to set my customized tools bars, options,
etc., - from scratch.

Is there a way, such as files where my preferences and customized
options reside and that can be copied from one PC and pasted to
another, so that when I start XL the menus, tool bars, options, etc.
look as my older XL?

Thanks

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=537586

If you are going to establish the setting manually once, consider turning on
the macro recorder when you do it:

Sub Macro1()
With Application
.ReferenceStyle = xlR1C1
.UserName = "Garys Student"
.StandardFont = "Arial"
.StandardFontSize = "10"
.DefaultFilePath = "C:\Documents and Settings\Owner\My Documents"
.EnableSound = False
.RollZoom = False
End With
End Sub


is just a small sample of what you can record.


Once you have the macro defined to your satisfaction, you can run it on any
new machine you are given.
--
Gary's Student


"Ingeniero1" wrote:


Just bought a new PC; this one with Win XP and XL 2003. The old one had
Win ME and XL 2002.

Each time, whether for a new PC, or a new installation on an existing
PC, or whatever, I have had to set my customized tools bars, options,
etc., - from scratch.

Is there a way, such as files where my preferences and customized
options reside and that can be copied from one PC and pasted to
another, so that when I start XL the menus, tool bars, options, etc.
look as my older XL?

Thanks

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=537586

Yes, I understand that, but wondered if I could 'copy and paste' what I
already have done on another PC.

Also, which I forgot to bring up and your post reminded me, I have
several macros recorded on the other PC, for MS XL as well as for MS
Word, and would like to copy them as well. Possible?

Actuually, all my questions apply to both XL and Word, for which I have
customized the menus, tool bars, and written macros.

Thanks

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=537586

You might try to copy your EXCEL10.xlb or EXCEL11.xlb file to the new
computer. I have tried this in the past, but it has never been fully
successful. Thats why I use the macro approach.
--
Gary's Student


"Ingeniero1" wrote:


Yes, I understand that, but wondered if I could 'copy and paste' what I
already have done on another PC.

Also, which I forgot to bring up and your post reminded me, I have
several macros recorded on the other PC, for MS XL as well as for MS
Word, and would like to copy them as well. Possible?

Actuually, all my questions apply to both XL and Word, for which I have
customized the menus, tool bars, and written macros.

Thanks

Alex


--
Ingeniero1
------------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
View this thread: http://www.excelforum.com/showthread...hreadid=537586

Alex

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 ToolsOptions
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 "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

On Sun, 30 Apr 2006 10:09:58 -0500, Ingeniero1
wrote:


Just bought a new PC; this one with Win XP and XL 2003. The old one had
Win ME and XL 2002.

Each time, whether for a new PC, or a new installation on an existing
PC, or whatever, I have had to set my customized tools bars, options,
etc., - from scratch.

Is there a way, such as files where my preferences and customized
options reside and that can be copied from one PC and pasted to
another, so that when I start XL the menus, tool bars, options, etc.
look as my older XL?

Thanks

Alex

Gord Dibben MS Excel MVP