saving macros in personal workbook

[Guest]

On recording a macro in my personal workbook everything seems fine. If I
close down excel and reopen the macro has been deleted and the elements put
into the trash can. i assume I must have a setting somewhere that is deleting
the macro, but I don't know what. Please help!!

 

[Guest]

You have to save the personal workbook, whenever you write a new macro to it
if you want to keep it.

When I close excel, after putting a macro in the personal.xls, it asks me if
I want to save the file. If yours is not doing this, there may be a setting
somewhere which needs to be set.

another way to do it is from the view Visual Basic location.
make sure one of the personal workbook items is selected then goto file and
select save personal.xls