Personal.xls

D

Dave Peterson

Personal.xls is an excel workbook that's usually stored in your XLStart folder.
If you don't do anything special, the first time it's created (and saved), it
will be a hidden workbook--so you may not notice it.

If you created the macro by recording your actions, you may have chosen
personal.xls in that first dialog. (There's a dropdown list asking where the
recorded macro should be stored.)

And lots of people use this personal.xls workbook to store macros that they want
available each time they open excel (hence the XLStart folder--you can find that
by using Windows start button|search and looking for XLStart).
 
C

Chip Pearson

John,

Personal.xls is simply a workbook. Typically, it is located in
the XLStart folder (e.g., C:\Program Files\Microsoft
Office\Office\XLStart), and opened whenever you start Excel. One
usually stores in personal.xls macros that need to be available
all the time, regardless of what workbooks are open. There is
nothing special about personal.xls -- it is just another
workbook.


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

DoctorG

Being an old DOS programmer I like to think of Personal.XLS as my Global
function (macro) library for pieces of code that are reusable, as opposed to
code that is spreadsheet-specific and naturally lies within that specific
spreadsheet.
 
J

John

Thanks to one and all

DoctorG said:
Being an old DOS programmer I like to think of Personal.XLS as my Global
function (macro) library for pieces of code that are reusable, as opposed to
code that is spreadsheet-specific and naturally lies within that specific
spreadsheet.
Click to expand...
 
M

Melissa

Dave -

I have recorded a macro in my Excel 2003 personal.xls. Can I share this
macro with another user rather then re-recording the macro on her machine?

Thanks.....
 
G

Gerry

I had a macro (a long one) saved in my Personal Macro Workbook, but it has
all of a sudden disappeared. Any idea why?
 
D

Dave Peterson

Maybe you're opening the wrong workbook????

Maybe you've lost the complete file????
 
Top