View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default 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