If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to copy/transfer custom buttons and
I've created a number of custom buttons and toolbars. How do I copy these to
transfer to another machine or in case of an upgrade? Thanks, Bob |
#2
|
|||
|
|||
Does anyone know the answer to the question? It's been posted twice. Thanks,
Bob "bobs" wrote: I've created a number of custom buttons and toolbars. How do I copy these to transfer to another machine or in case of an upgrade? Thanks, Bob |
#3
|
|||
|
|||
Depends on how you created them.
If you just modified the toolbars via tools|customize, then your changes have been stored in your .xlb file. This is difficult to share. You could just share that *.xlb file and overwrite the other person's *.xlb file. But if you overwrote my *.xlb file, I'd be ticked off. If you attached the toolbars to workbook, then you could share that workbook with the other users. If you've done that, you'll want to read Jan Karel Pieterse's notes: http://google.com/groups?threadm=083...0a% 40phx.gbl If I had my choice, I'd create the buttons/toolbars on the fly. I like the way John Walkenbach did it in his menumaker.xls workbook. http://j-walk.com/ss/excel/tips/tip53.htm It's easy to update and looks really professional. And for toolbars, I like this: http://groups.google.com/groups?thre...5B41%40msn.com bobs wrote: I've created a number of custom buttons and toolbars. How do I copy these to transfer to another machine or in case of an upgrade? Thanks, Bob -- Dave Peterson |
#4
|
|||
|
|||
Bob
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 2000 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 Wed, 20 Oct 2004 16:19:01 -0700, "bobs" wrote: Does anyone know the answer to the question? It's been posted twice. Thanks, Bob "bobs" wrote: I've created a number of custom buttons and toolbars. How do I copy these to transfer to another machine or in case of an upgrade? Thanks, Bob |
#5
|
|||
|
|||
I misread the question--I thought you were sharing the toolbars--not just
copying to a second pc for your own use. Dave Peterson wrote: Depends on how you created them. If you just modified the toolbars via tools|customize, then your changes have been stored in your .xlb file. This is difficult to share. You could just share that *.xlb file and overwrite the other person's *.xlb file. But if you overwrote my *.xlb file, I'd be ticked off. If you attached the toolbars to workbook, then you could share that workbook with the other users. If you've done that, you'll want to read Jan Karel Pieterse's notes: http://google.com/groups?threadm=083...0a% 40phx.gbl If I had my choice, I'd create the buttons/toolbars on the fly. I like the way John Walkenbach did it in his menumaker.xls workbook. http://j-walk.com/ss/excel/tips/tip53.htm It's easy to update and looks really professional. And for toolbars, I like this: http://groups.google.com/groups?thre...5B41%40msn.com bobs wrote: I've created a number of custom buttons and toolbars. How do I copy these to transfer to another machine or in case of an upgrade? Thanks, Bob -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Thanks Gord and Dave! I'll give your advice a try.
"Dave Peterson" wrote: I misread the question--I thought you were sharing the toolbars--not just copying to a second pc for your own use. Dave Peterson wrote: Depends on how you created them. If you just modified the toolbars via tools|customize, then your changes have been stored in your .xlb file. This is difficult to share. You could just share that *.xlb file and overwrite the other person's *.xlb file. But if you overwrote my *.xlb file, I'd be ticked off. If you attached the toolbars to workbook, then you could share that workbook with the other users. If you've done that, you'll want to read Jan Karel Pieterse's notes: http://google.com/groups?threadm=083...0a% 40phx.gbl If I had my choice, I'd create the buttons/toolbars on the fly. I like the way John Walkenbach did it in his menumaker.xls workbook. http://j-walk.com/ss/excel/tips/tip53.htm It's easy to update and looks really professional. And for toolbars, I like this: http://groups.google.com/groups?thre...5B41%40msn.com bobs wrote: I've created a number of custom buttons and toolbars. How do I copy these to transfer to another machine or in case of an upgrade? Thanks, Bob -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom buttons on toolbar | tess457 | General Discussion | 1 | October 2nd, 2004 12:22 AM |
Custom Buttons linked to Macros | surveyorinva | General Discussion | 1 | June 16th, 2004 06:37 PM |
Macro Custom Buttons - How do I delete them | Sheila | Worksheet Functions | 5 | June 1st, 2004 02:40 PM |
Using .bmp or .ico for custom excel toolbar buttons | Don Guillett | Worksheet Functions | 1 | November 9th, 2003 09:29 PM |