Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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/groups?th...5B41%40msn.com PG wrote: 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" wrote: 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 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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 PG wrote: 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" wrote: 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 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
In xl2003/winXPPro, I found mine in the same path.
"Dave Peterson" wrote: 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 PG wrote: 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" wrote: 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 -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I import custom Excel buttons?
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. "Dave Peterson" wrote: 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/groups?th...5B41%40msn.com PG wrote: 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" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to import Outlook Contact data into Excel | Excel Discussion (Misc queries) | |||
Excel Blank Value Import | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
How do I import a WORD file into EXCEL? | Excel Discussion (Misc queries) | |||
How do I import a WORD file into EXCEL? | Excel Discussion (Misc queries) |