How do I make a VBA procedure available to all workbooks?
 

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

How do I make a VBA procedure available to all workbooks?
 

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

How do I make a VBA procedure available to all workbooks?
 

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