Don't understand personal workbooks
 

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?
Thanks!
Samuel

Don't understand personal workbooks
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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?
Thanks!
Samuel

Don't understand personal workbooks
 

Samuel

When you go to ToolsMacroRecord New Macro a dialog box will open to name the
macro.

Also where to store it.

Select "Personal Macro Workbook" to record to.

This will record the macro into Personal.xls which is stored by Excel in your
XLSTART folder.

You can copy your existing macros into a standard module in the Personal.xls you
just created.

Remember to save it as "Hidden" so's it opens in the background.


Gord Dibben MS Excel MVP


On 27 Apr 2007 11:24:14 -0700, Samuel wrote:

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?
Thanks!
Samuel

Don't understand personal workbooks
 

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/

Don't understand personal workbooks
 

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