Possible to make macros available to other workbooks?

[jazminecat]

Hi all, is it possible to save macros such that they are available for use in other Excel workbooks on the same workstation? Thanks!

 

[PHV]

Yes, and the best place is your Personal.xls file.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WalterContrata]

jazmincat,

PHV is surely correct for vast majority of cases. Also,
there is another method for calling macros of other workbooks in thread707-1120591.

Best Regards,
Walter

 

[jazminecat]

Thanks to both of you! I will have my user try these and see what works best for her.