When you have macros and want those macros to be available to any workbook
you open, you store them in a file called Personal.xls which is stored in
the XLStart directory. The Personal.xls file opens as a hidden workbook when
you start Excel. This file doesn't exist until you create it by recording a
macro (or you could do it all manually). When you start the macro recorder
you're presented with a dialog box asking you where you want to store the
macro you're about to create.

For example, I do a lot of testing and need to generate lots of random
numbers all the time. So I have a macro that generates these random numbers.
I need to have this available to any file I'm working on so I store this
macro in Personal.xls. I added a custom button to one of my toolbars and
then assigned that macro to that button. This saves me a lot of time and I
don't have to fool around writing a bunch of RAND/RANDBETWEEN functions (and
their volatility).

--
Biff
Microsoft Excel MVP


"driller" wrote in message
...
sorry to interrupt,

What's the main objective of the personal.xls in excellation...? before
and
now..


regards,
driller
--
*****
birds of the same feather flock together..



"T. Valko" wrote:

When you say "Personal is not hidden", what exactly do you mean?

Normally, it's a *hidden file* in the XLStart directory and it opens as a
*hidden workbook* when you start Excel. So, which of those "not hiddens"
are
you referring to?

You need to set your folder options to display hidden files and
directories
then you'll probably find it in the XLStart directory where you can
delete
it.

--
Biff
Microsoft Excel MVP


"Pat-southern-California"

wrote in message
...
I want to get rid of personal.xls. I don't need the macro. Personal is
not
hidden but I cannot get to it. I went into XLStartup, not there
either.

I noticed a posting from 2004 said "delete it." I wish I could.

Pat from southern California.