Open statement doesn't work on protected workbooks

Hi all,

Hope any of you can help me with this. I have a workbook that needs to open another workbook which is protected by password. However, before opening this second workbook, I would like to check if the workbook is already open by someone else. Now, I thought of the options to do so: the Workbook.Open statement and the Open statement. However, the former gives me a pop-up box when I try to open it (e.i: "The file is locked for editing by John Doe. Do you want to save a local copy or open in read-only?"), the latter doesn't seem to work on protected workbooks.

Can anyone please help me out to make one of these lines of code work?

Please Login or Register  to view this content.

This first code gives me the pop-up window I was talking about, could someone tell me how to disable this pop-up? I tried Application.Displayalerts=False, no use.

Please Login or Register  to view this content.

This second piece of code doesn't seem to work with password protected workbooks. Does anyone know how to make it work?

Thanks SHG, will give it a try! Will let you guys know if the easy solution did it

Worked like a charm, easy does it, as always