Open workbook from vba with password if another user is in file

On the workbook_open code of a fileA, I check a user list from fileB. If another user has fileB open, fileA has a password prompt box to open the workbook.

As is stands I am using workbooks.open(fileB, , ,"password")

work fine unless another use has the file on the computer. also does not give read-only option.

I tried using IgnoreReadOnlyRecommended:=True or ReadOnly=true but none of these can get past the password prompt.

Any ideas?