Good afternoon Soopial -
The easiest way to create this file is to record a macro - it doesn't have to do anything just start the recorder -
you will see an option - usually the default - that puts it in the Personal file - click on a cell and then stop the recorder.
The file will be created - it is a hidden file - so you need to go to the WINDOW menu and select unhide - select the Personal file
and click on OK.
You can then use the VBA editor and edit - add - remove macros from the Personal file.
When you are done you should re-hide the Personal workbook and when you exit excel - save the changes.
This makes it a Global Macro workbook-
You need to make sure that your code points to the active workbook or a specific workbook by name or
the macros will run on the Personal workbook and will not accomplish anything, the way you want.
Please let me know if you need further help with this issue.
Thanks,
Jon Barchenger
--------------------
**Content-Class: urn:content-classes:message
**From: "soopial" <
[email protected]>
**Sender: "soopial" <
[email protected]>
**Subject: Personal.xls
**Date: Fri, 5 Dec 2003 08:21:34 -0800
**Lines: 13
**Message-ID: <
[email protected]>
**MIME-Version: 1.0
**Content-Type: text/plain;
** charset="iso-8859-1"
**Content-Transfer-Encoding: 7bit
**X-Newsreader: Microsoft CDO for Windows 2000
**X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
**Thread-Index: AcO7S9m1Ju5maXXzRUyY1NAq6EYm3g==
**Newsgroups: microsoft.public.excel.worksheet.functions
**Path: cpmsftngxa07.phx.gbl
**Xref: cpmsftngxa07.phx.gbl microsoft.public.excel.worksheet.functions:175185
**NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
**X-Tomcat-NG: microsoft.public.excel.worksheet.functions
**
**I have no file entitled personal.xls
**I checked both paths (program
**files\msoffice\office\xlstart AND documents and
**settings\soopial\application data\microsoft\excel\xlstart
**(although the latter is where I found the excel.xlb file)
**
**I wrote two macros that I want to be available for use in
**ALL workbooks but cannot figure out where this key file
**is or how I can create one.
**And, once this file does exist, how can I move the macros
**already written to reside there for all workbooks to use?
**
**Can you help me, please?
**
