IIRC, the location of XLStart could vary with the version of Excel and the
Version of Windows. And depending on how you upgraded/installed excel, excel
will be smart enough to look at the old locations.

I like to open excel
go into the VBE (alt-f11)
and show the immediate window and type this:
?application.startuppath

To let excel tell me what it wants to use (this time).

Then I go and move everything out of those other XLStart folders (and put them
in that new location).

(I used to delete the old XLStart folders so that I wouldn't be confused when/if
I searched for XLStart.)

Stan Brown wrote:

Fri, 27 Apr 2007 20:45:39 +0200 from Ron de Bruin
:
"Samuel" wrote in message ups.com...
I've written a couple of macros that only appear in the book open at
the time. I want all my macros available at all times. How does one
place all macros in a personal workbook, then make that personal
workbook always available to any macro? Or.. is this the right way to
do this? Any other way to make all macros always available?

See this page Samuel
http://www.rondebruin.nl/personal.htm

That page locates the XLSTART folder in
C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART

I've only seen it in
C:\Program Files\Microsoft Office\OfficeNN\XLSTART

What would cause the location to change?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

--

Dave Peterson