Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
personal macro workbook
Dave Peterson
Thank u the problem of personal macro WB SOLVE -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
Personal Macro Workbook | Excel Discussion (Misc queries) | |||
Personal Macro Workbook | Excel Discussion (Misc queries) | |||
Where is Personal Macro Workbook? | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) |