--
FIV

First, thank you very much for your reply and your assistance, Otto.

I record a macro in a separate worksheet. I will use this macro on many new
worksheets I create. Therefore, I save it in the Personal Macro Workbook.
My other choices from the dropdown menu are in this workbook or a new
workbook.

Once I record it, it shows up in the personal.xls module viewed through VB
Editor.

I then go about creating the different workbooks using the macros I created.
The Personal.xls stays open. I can view the macros by viewing the macros
available in the personal.xls.

I have lost these macros before. Last time it happened I had closed the
personal.xls. When I went to run a macro in a new workbook, it did not run.
I reopened the personal.xls where I had stored the macros and they could not
be found. I had used these macros for a number of days before I lost them.

Should I save the macro elsewhere besides the personal.xls? It is quite
disturbing because it takes quite some time to re-record the macros.

I have done a search trying to find another personal.xls but I can't find
another one. The personal.xls is stored in C:\Documents and
Settings\Application Data\Microsoft\Excel\XLStart.

The only thing I can think of is I didn't save the personal.xls as I did
close it before the other workbooks. I did not receive a "do you want to
save this" prompt.

Again, I appreciate the help. If there is a better way to save and store
macros that I should be using, please let me know.

Take care!
Jim



"Otto Moehrbach" wrote:

They shouldn't get lost. What are you doing when you "that I create and
store in PERSONAL.XLS"? Exactly what are you doing? In detail.
Also, exactly how are you going about finding out that those macros are not
in Personal.xls? In detail.
I am asking these questions because many times people end up with 2
Personal.xls files, in different folders. Excel accesses only one of them
and will access only that same one every time. If you are putting (how?)
some macros in one Personal.xls file and Excel access the other, you will
think the macros are lost. HTH Otto

"Frustrated in Vegas" wrote in message
...

--
FIV

It looks to me like you have 2 Personal.xls files. You say:
"I have lost these macros before. Last time it happened I had closed the
personal.xls. When I went to run a macro in a new workbook, it did not run.
I reopened the personal.xls where I had stored the macros and they could not
be found. I had used these macros for a number of days before I lost them."

Let's look at this one piece at a time. You say that the last time this
happened you had closed Personal.xls. This is not right. The Personal.xls
file that Excel accesses should be a hidden file in the XLStart folder
(there might be 2 such folders). Excel opens every file that is in the
XLStart folder (in only one of the 2 XLStart folders if there are two) when
Excel opens, so Excel will open the Personal.xls file. That file doesn't
HAVE to be a hidden file and it CAN be closed with Excel still running. But
it is best if you leave that file hidden. As such you can't close it with
Excel running. You can view the code in that file and add or delete code as
you wish in the VBE as you said, without making the file visible.

Do this:
Close all programs, including Excel.
Open Excel.
Click on Window - Unhide
If the Unhide menu item is not accessible, then you don't have a
Personal.xls file in the XLStart folder that your version of Excel is
accessing.
If Unhide is available, Unhide the Personal.xls file if there is one there.
The Personal.xls file usually has only one sheet. Select that sheet, or any
sheet you want if there is more than one.
In some accessible cell, like A1, type "This is the real Personal.xls file".
Save the file.
Close the Personal.xls file.
Now go find the Personal.xls file that you have found before and open it.
What is in cell A1 of the sheet you selected before?

When you are thoroughly frustrated and just before you shoot yourself, call
me and we'll try to work it over the phone. My phone is 770-992-9384 and
I'm in Georgia. Call me after 8:00AM ET. HTH Otto

"Frustrated in Vegas" wrote in message
...
First, thank you very much for your reply and your assistance, Otto.

I record a macro in a separate worksheet. I will use this macro on many
new
worksheets I create. Therefore, I save it in the Personal Macro Workbook.
My other choices from the dropdown menu are in this workbook or a new
workbook.

Once I record it, it shows up in the personal.xls module viewed through VB
Editor.

I then go about creating the different workbooks using the macros I
created.
The Personal.xls stays open. I can view the macros by viewing the macros
available in the personal.xls.

I have lost these macros before. Last time it happened I had closed the
personal.xls. When I went to run a macro in a new workbook, it did not
run.
I reopened the personal.xls where I had stored the macros and they could
not
be found. I had used these macros for a number of days before I lost
them.

Should I save the macro elsewhere besides the personal.xls? It is quite
disturbing because it takes quite some time to re-record the macros.

I have done a search trying to find another personal.xls but I can't find
another one. The personal.xls is stored in C:\Documents and
Settings\Application Data\Microsoft\Excel\XLStart.

The only thing I can think of is I didn't save the personal.xls as I did
close it before the other workbooks. I did not receive a "do you want to
save this" prompt.

Again, I appreciate the help. If there is a better way to save and store
macros that I should be using, please let me know.

Take care!
Jim



"Otto Moehrbach" wrote:

They shouldn't get lost. What are you doing when you "that I create and
store in PERSONAL.XLS"? Exactly what are you doing? In detail.
Also, exactly how are you going about finding out that those macros are
not
in Personal.xls? In detail.
I am asking these questions because many times people end up with 2
Personal.xls files, in different folders. Excel accesses only one of
them
and will access only that same one every time. If you are putting (how?)
some macros in one Personal.xls file and Excel access the other, you will
think the macros are lost. HTH Otto

"Frustrated in Vegas" wrote in message
...

--
FIV