personal macro workbook

[helmekki]

i have problem opening the mentioned WB

it is not found in XLStart folder

i tried to make macro and choose to save it in personal macro workbook,
but the Excel keep giving this message:
*personal macro workbook must be open
*unable to record

however, to save macros in the other WB, is ok
i even went to option>general. at start up....could not find any file

pls help

 

[Dave Peterson]

What version of excel are you using?

If it's xl2002 or xl2003, then your personal.xls file may have been disabled by
excel.

You can check by looking under:
Help|about MS Excel|Disabled Items button

If it shows personal.xls being disable, you can try to reenable it.

If the file was really bad and excel wants to keep disabling it, delete that
file and restore a copy from your backups.

 

[helmekki]

Dave Peterson
Thank u

the problem of personal macro WB SOLVE

 

[Spalding]

That didn't work for me in xL2002 - nothing is disabled, and there is n
sign of personal.xls anywhere, not even in help. Did they do away wit
it? Should I just create one

 

[Dave Peterson]

It only exists if you created it.

If you think you did create it, you may want to search your harddrive for
personal.xls

Windows start button|search (or Find)
personal.xls

You may have to change a setting to search for hidden files in hidden folders.