hi
you seem to have two questions.
subject:Separate macro from workbook.
no. can't be done.
not sure about your second question. if it's in the xls start folder, it
will open with excel and all macros in the open workbooks can be use on other
files provided they are generic ie make no reference to a specific workbook
name or worksheet name.

if i didn't answer your question, post back with more detail.

Regards
FSt1

"jswalsh33" wrote:

In response to a question on allowing a macro to be available for all files
in Excel dated 5/17/09, FST1 wrote a solution that did what was requested.

Namely:
C:\Program Files\Microsoft Office\Office12\XLSTART (i think).
The file will open automaticly(hidden) when excel starts and all macros in
the personal.xlsb will be available for use on all files.

My question is can the same be done for certain Excel workbooks but not
others?

Any help will be greatly appreciated.

Jim Walsh