Thank you Gord for your reply as well. But I can't seem to find the
personal.xls or the Excelxx.XLB file anywhere in my computer. I tried doing
a search on all my directories, and they are nowhere to be found. Are they
hidden files or in hidden folders?? When the search is running, it does say
that the search is not looking in hidden folders or hidden files.
Another question is, if I succeed in creating a customized toolbar, as
outlined in your instructions, does that mean I don't have to email the
personal.xls file as well? Or do I have to do both steps?
"Gord Dibben" wrote:
Sending Personal.xls home will get your macros home but if you have made a
custom toolbar with buttons to run the macros, they will not be available on
your home computer.
Customizations to Menus and Toolbars are saved in your Excelxx.XLB file.
If only a customized Toolbar, you could attach it to Personal.xls.
Otherwise you could send the Excelxx.XLB file home also and overwrite your
current one on home computer.
This is not always desirable.
Best method of assigning macros to buttons is to build the Toolbar when you open
the workbook and delete it when you close.
Do not make the changes to the existing toolbars.
See Debra Dalgleish's website for Dave Peterson help on building "on the fly"
toolbars and menus.
http://www.contextures.on.ca/xlToolbar02.html
Gord Dibben MS Excel MVP
On Fri, 8 Dec 2006 07:51:00 -0800, TT wrote:
I see. Thank you very much. Now I understand. I'll try it and let you know
if it works.
"CLR" wrote:
Email the personal.xls file home. You can find it by doing Start Search
For files and folders in Windows Explorer........you may have to re-create
the buttons at home but you'll have the macros.
Vaya con Dios,
Chuck, CABGx3
"TT" wrote:
When I created the macros, I didn't save them in a particular file. Instead,
I saved them in my personal.xls, which can then be applied to all the files I
open using the application.
I know for sure these macros are not associated with the file because if I
open the file in someone else's computer, there's no macros buttons on their
excel application.
"CLR" wrote:
Macros that are recorded are stored in the same file that you recorded them
in. When you save that file, you save the macros therein. Just email that
file home and the macros will be there when you open it.
Vaya con Dios,
Chuck, CABGx3
"TT" wrote:
The problem is I have no idea where the macros are saved. The macros I
created are not custom macros (I'm only a beginner in macros, and I only know
how to create macros using the "record macro" function, and then assigning
them to a button), so I don't know where this type of macros are saved, or
how they are saved.
"CLR" wrote:
If the macros reside in an Excel file, just email it........
Vaya con Dios,
Chuck, CABGx3
"TT" wrote:
I have created a whole bunch of macros on my work computer. How do I copy
all these macros to my home computer??
Gord Dibben MS Excel MVP