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 originall
programme

--
ebsjunio
-----------------------------------------------------------------------
ebsjunior's Profile: http://www.excelforum.com/member.php...fo&userid=1519
View this thread: http://www.excelforum.com/showthread.php?threadid=26828

You can't. If it isn't open, you can't use its macros.

You could store it in Personal.xls which gets stored in XLStart, and opens
when Excel starts.

--

HTH

RP

"ebsjunior" wrote in message
...

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


--
ebsjunior
------------------------------------------------------------------------
ebsjunior's Profile:
http://www.excelforum.com/member.php...o&userid=15197
View this thread: http://www.excelforum.com/showthread...hreadid=268284

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