PERSONAL.XLS is locked for editing

nigel_root · May 14th, 2002, 05:09 AM

New to Excel 2000 VBA, I've written a couple of macros in a couple of Excel spreadsheets, storing them in personal.xls. One colleague's spreadsheet had a password.

Now I want to go back into Excel, but cannot use personal.xls because it's locked.

This is all on my laptop, no-one else s/be using it. Laptop has been off overnight.

Ideas how to unlock my own work gratefully received. Thanks and regards. Nigel.

stone · May 14th, 2002, 05:16 AM

Hi Nigel.

Have you check out the following link?
http://j-walk.com/ss/other/pword.htm

I dont knoe if it works, i have not tried it out.

BK
Stulli

Audiojoe · May 14th, 2002, 05:17 AM

I get this quite a bit. Could anyone else be using your log in? Is your system part of a network?

The other cause could be that you're trying to access it in a shared workbook?

nigel_root · May 14th, 2002, 08:41 AM

Thanks for your help.

I cleared the problem by rebooting the laptop standalone, and working in Excel there. Whether that's the whole story remains to be seen, but I consider this closed for now.

Regards,

Nigel.

gareth · May 14th, 2002, 08:48 AM

Nigel

If that sought of thing happens again,go to the properties of the specific folder and add yourself as an administrator and allow all uses for the worksheet.

May 14th, 2002, 08:48 AM	#5
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Nigel If that sought of thing happens again,go to the properties of the specific folder and add yourself as an administrator and allow all uses for the worksheet. __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 05:09 AM	#1
nigel_root New Member Join Date: May 2002 Posts: 2	New to Excel 2000 VBA, I've written a couple of macros in a couple of Excel spreadsheets, storing them in personal.xls. One colleague's spreadsheet had a password. Now I want to go back into Excel, but cannot use personal.xls because it's locked. This is all on my laptop, no-one else s/be using it. Laptop has been off overnight. Ideas how to unlock my own work gratefully received. Thanks and regards. Nigel.

May 14th, 2002, 05:16 AM	#2
stone Board Regular Join Date: Apr 2002 Location: iceland Posts: 138	Hi Nigel. Have you check out the following link? http://j-walk.com/ss/other/pword.htm I dont knoe if it works, i have not tried it out. BK Stulli

May 14th, 2002, 05:17 AM	#3
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	I get this quite a bit. Could anyone else be using your log in? Is your system part of a network? The other cause could be that you're trying to access it in a shared workbook?

May 14th, 2002, 08:41 AM	#4
nigel_root New Member Join Date: May 2002 Posts: 2	Thanks for your help. I cleared the problem by rebooting the laptop standalone, and working in Excel there. Whether that's the whole story remains to be seen, but I consider this closed for now. Regards, Nigel.