Jim, Tom,
Good / helpful answers from each of you - thanks.
--chris
"Tom Ogilvy" wrote:

Just to add,
All macros are stored in workbooks - unlike word, there is not normal.dot or
template that is used to store common macros. As Jim has said, macros from
one workbook can be run on any workbook. However, to call a macro in one
workbook from another workbook, the calling workbook would either have to
have a reference set to the other workbook or would have to use application
run.

--
Regards,
Tom Ogilvy


"cs" wrote:

Wondering where are global (non-local module) VB macros kept in Excel in
Microsoft Office once you have written them?
Are they compressed within Excel?
Are separate files (and extentions) created for global macros?
Email response appreciated...Thx,