personal macro workbook
 

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 optiongeneral. at start up....could not find any file

pls help


---
Message posted from http://www.ExcelForum.com/

personal macro workbook
 

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 <" wrote:

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 optiongeneral. at start up....could not find any file

pls help

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

personal macro workbook
 

Dave Peterson
Thank u

the problem of personal macro WB SOLVE

--
Message posted from http://www.ExcelForum.com

personal macro workbook
 

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

--
Message posted from http://www.ExcelForum.com

personal macro workbook
 

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.


"Spalding <" wrote:

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

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson