You don't save macros to xlb files. Inbar is mistaken. xlb files hold
menu modifications.

--
Regards,
Tom Ogilvy

"TommyBoy" wrote in message
...
how do i save it to the xlb file?

Inbar wrote:

How did you create the macro?
If you use the VBA editor you can save the macro as part of a worksheet
or
in the xlb file so it will be there everytime you launch Excel.

Inbar.

"TommyBoy" wrote:


i have a macro i created that emails worksheets, it needs to be used on
different workbooks, but when i import it into a workbook at runtime it
doesn't find it, do i have to save the vbproject first? or does anyone
know what is going on?