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