In my current code I've set both the above attributes to false, but when I
try to open a workbook someone else is in using the code I still get the
dialog box asking if I want to open it Read Only, Notify when it's read-write
or Cancel.

I want to try and automate this as much as possible because I need to open
10 spreadsheet and take one tab from each into a master sheet and I don't
want to sit there clicking Read Only each time.

Any ideas??