PERSONAL.xls is locked for editing

[Christoffer Bloch Andersen]

Hey

I currently did some amcro typing in Visual Basic, but I made a stupid thing
by deleting som text..

So now, everytime I want to open a second workbook it appears with the
message: PERSONAL.xls is locked for editing, and I have to select Read-Only,
Notify or cancel to get in to the workbook...

This kinda annoying, so my Question is to you: Is there any special
prgramming in VBA that must not be deleted and how to fix this?

PS. I have already tried the Detect and repair thingy, but it didnt work

BR

 

[Mike H]

Hi,

This 'problem' is almost always caused by opening a second instance of Excel
where the first will already have opened personal.xls and you should avoid
doing this in your code.

Mike

 

[Dave Peterson]

Just to add to Mike's response.

I don't like to use multiple instances of excel, either.

But if you do, you can mark your personal.xls as readonly (using windows
explorer). Excel won't give you that message anymore--but you'll have more work
to do if you decide to update your personal.xls workbook.

I use an addin (personal.xla) instead of a .xls file. And I don't have to worry
about that message (the file is not marked readonly.)