hi
yes. a workbook has to be open to run it's macro. that is why some people
put macros in their personal workbook in the xl start folder so that the
macros will be available for all files. so in your case, i think you would
have to export.
and you're on the right track about import and export.
in the vb editor, expand the project and right click the macro, click export.
it will export as a bas file. I use to have a special folder for all of the
macros i had exported. to import, in the vb editor, right click the project
you want the macro in. click import. you may need to decide if it's a sheet
macro, workbook macro or just in a standard module.
good luck
Regards
FSt1
"Tail Wind" wrote:

Hi,

I have two workbooks. One contains nearly all the macros being used by both
workbooks. I need to share these workbooks with other users and wish to make
each workbook's macros work whether or not the other workbook is open or not.

Do I need to export the macros from one workbook to the other?

Assuming the answer is YES, can I right click on the origin workbook
"Modules" heading and "Export" to the default filenames, then in the
destination workbook in Modules, right click and use "Inport"?

Is there a trap I need to know about?

Still learning as I go!

Many thanks in advance,
Brian