Don't understand personal workbooks

S

Samuel

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
 
G

Gord Dibben

Samuel

When you go to Tools>Macro>Record 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
 
D

Dave Peterson

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.)
 
Top