I’ve just been working on an Excel problem that requires one worksheet to be opened at a given time (using the Windows Task Scheduler) and a macro run.
However, when testing this I came across the “Personal.XLS locked for editing” message.
It seems that this is due to having more than one instance of Excel running at one time.
Dave Peterson at http://www.pcreview.co.uk/forums/thread-2831009.php has suggested a solution to this.
This involves marking the personal.xls file as read-only and this, indeed, seems to stop the error.
If you haven’t come across the personal.xls file before it’s a hidden workbook that opens when you start Excel. Any code in this workbook is available in all workbooks you have open in Excel.
On a Windows XP machine the file is usually located in the Excel startup folder at:
C:\Documents and Settings\[UserName]\Application Data\Microsoft\Excel\XLSTART
If you’re using Vista it’s probably in the folder at:
C:\Users\[UserName]\AppData\Roaming\Microsoft\Excel\XLSTART
where [UserName] is the user name you’re currently logged onto the machine as.
However, the file could be located elsewhere so use Search to find it if it’s not in the folders mentioned above.
Although making the file read-only solves this problem it does raise other issues if you often add code to personal.xls but is a useful workaround in my situation.
0 Responses to “Excel VBA – PERSONAL.XLS Locked For Editing – Resolution”