View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default independent macros

A macro must be contained in a workbook, and that workbook must
be open in order to execute the code. Most people put common
procedures in their Personal.xls workbook, typically located in
C:\Program Files\Microsoft Office\Office\XLStart. Files in that
folder will automatically open when Excel starts.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"XCESIV"
wrote in message
...

I am wanting to make a macro independent of any specific
workbooks.

I would like the macro to be available for every workbook i
start in
Excel.


Is this possible, if so how?


--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile:
http://www.excelforum.com/member.php...o&userid=24271
View this thread:
http://www.excelforum.com/showthread...hreadid=544495