View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how do I import custom Excel buttons?

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.

PG wrote:

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" wrote:

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.

PG wrote:

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


--

Dave Peterson