You can't. The normal way to handle this is to put the code in a workbook
that's stored in your XLSTART directory, so it automatically loads when you
open Excel.

On Mon, 11 Oct 2004 15:24:03 -0500, ebsjunior
wrote:


How do I make a macro (VBA procedure that also uses a User Form)
available to any existing or new workbook that I open or create,
without having to open the workbook where the macro was originally
programmed