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

"Dave Peterson" wrote:

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

John wrote:

What does Personal.xls do? What is it?

--

Dave Peterson