Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Darrell
 
Posts: n/a
Default Transferring toolbars and macros to other machines

Hello
How do you transfer macros and toolbars from one machine to another? If I
copy "personal.xls" to another machine, it'll overwrite everything there.
MS Word has "Organizer" that makes this easy but Excel doesn't have that
feature.

Thanks in advance.


  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Well, you can rename personal to personal1, open BOTH files, then go into
the VB Editor (Alt+F11) and click and drag modules down into the other file.
Make sure you hit your save diskette when you're done. The toolbar is a bit
different. It's *.xlb where the * is your username.
************
Anne Troy
www.OfficeArticles.com

"Darrell" wrote in message
news:_6U3f.24045$Io.5107@clgrps13...
Hello
How do you transfer macros and toolbars from one machine to another? If I
copy "personal.xls" to another machine, it'll overwrite everything there.
MS Word has "Organizer" that makes this easy but Excel doesn't have that
feature.

Thanks in advance.




  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Darrell

Macros can be in any workbook. They would travel with the workbook.

Also in Personal.xls for global macros.

Also could be in any add-in(s) *.xla you created.

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

Excel 97.....username.xlb

Excel 2000...Excel9.clb

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 Fri, 14 Oct 2005 19:59:54 GMT, "Darrell"
wrote:

Hello
How do you transfer macros and toolbars from one machine to another? If I
copy "personal.xls" to another machine, it'll overwrite everything there.
MS Word has "Organizer" that makes this easy but Excel doesn't have that
feature.

Thanks in advance.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving custom toolbars with macros to work on other computers jpw48 Excel Discussion (Misc queries) 11 August 29th 07 01:09 AM
Why are my auditing and forms toolbars disabled? plb Excel Discussion (Misc queries) 0 September 23rd 05 03:41 PM
excel 2003 - macros & buttons mikey New Users to Excel 2 May 19th 05 11:51 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 01:21 AM
Providing Toolbars to Workgroup Sprinks Excel Discussion (Misc queries) 2 January 12th 05 02:51 PM


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"