File in Use and locked for editing in Excel 2007

[dboatrt]

I am trying to run a macro and everytime I select a file it tells me the file is in use and locked for editing. Why won't it let me open my file? Please help.

 

[Andrew Poulsom]

Welcome to the Board.

Does it say by whom the file is locked for editing? Ask that user to close the file.

 

[dboatrt]

No, it only states it locked for editing by " ".