Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with a procedure to make things easier | Excel Discussion (Misc queries) | |||
How do I make several workbooks work together? | New Users to Excel | |||
Procedure to make a dropdown list larger so it's easier to read | Excel Discussion (Misc queries) | |||
Make Macro available to all new workbooks | Excel Programming |