how do I import custom Excel buttons?

[Guest]

I just got a new computer at work. I had several custom-made buttons
assigned to macros on the old computer. I have successfully moved the macros
over, but I can't find where the custom buttons are saved, or how to import
them.

 

[Dave Peterson]

Is it the same version of excel?

If yes, then you may get lucky by just copying your *.xlb file to your new pc.

I like to modify a toolbar to find the correct *.xlb (both on the old and new
pc). Then use windows start button|search to get the correct location for both
the "sending" and "receiving" pcs.

Remember if you have macros assigned to these buttons, you'll want to copy the
workbooks to the other pc--and keep them in the same identical location--or
you'll be reassigning buttons to procedures.

 

[Guest]

both are 2003. old has SP1, new SP2.

I had copied the Excel11.xlb file to the same path and directory, but no
buttons. Now I may be in a worse pickle. I appear to have stumbled on an
older .xlb file. I double clicked it, and now my old PC does not have the
buttons.

What about the resume.xlw file? I remember having to save the workspace to
make the buttons appear, but I do not have any buttons when I open the
resume.xlw file either.

 

[Dave Peterson]

I don't use workspaces, so I don't have a guess.

Maybe if you search for all the *.xlb files, you'll be able to find the one you
want.

 

[Guest]

Unfortunately Excel11.xlb was the only one I found (besides Excel.xlb in an
old folder from the last PC change).

I'm beginning to think they were being kept in some type of "recent" file,
but not truly saved anywhere. It's looking like I should have saved the
toolbar, then I would have a *.xlb file to transfer as you suggest.

Looks like I'll have to recreate the buttons.

 

[Dave Peterson]

Are these buttons associated with macros you've written--or are they from
customizing the toolbar via Tools|Customize?

If they're for your own macros, you may find it much easier to just build those
toolbars on the fly.

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://groups.google.co.uk/[email protected]

Unfortunately Excel11.xlb was the only one I found (besides Excel.xlb in an
old folder from the last PC change).

I'm beginning to think they were being kept in some type of "recent" file,
but not truly saved anywhere. It's looking like I should have saved the
toolbar, then I would have a *.xlb file to transfer as you suggest.

Looks like I'll have to recreate the buttons.

 

[Dave Peterson]

ps. Remember to look through hidden folders for hidden files.

pps. My excel11.xlb (xl2003/winXP home) is in:
C:\Documents and Settings\(usernamehere)\Application Data\Microsoft\Excel

Unfortunately Excel11.xlb was the only one I found (besides Excel.xlb in an
old folder from the last PC change).

I'm beginning to think they were being kept in some type of "recent" file,
but not truly saved anywhere. It's looking like I should have saved the
toolbar, then I would have a *.xlb file to transfer as you suggest.

Looks like I'll have to recreate the buttons.

 

[Guest]

In xl2003/winXPPro, I found mine in the same path.

 

[Guest]

macros I've written. Buttons were created via
View|Toolbars|Customize|Commands Tab|Macros|Custom Button

I think I'll create much simpler buttons this time, so the next recreation
won't be so painful.

Thanks for the links.