Quote Originally Posted by SamT View Post
First, the obvious. Have you tried
Application.DisplayAlerts = False
Set Passdown = Workbooks.Open(Path & fileName, ReadOnly:=True)
DoEvents
Application.DisplayAlerts = True
Second, I know there are ways to read closed workbooks. Perhaps repost a rephrased question.

Sam T. Thanks for your response, I have tried that with no luck. It frustrates me that on my PC it works just fine, the workbook opens and closes as expected. I don't understand why on everyone else's PC's it immediately wants to save it, even though I've opened it in ReadOnly.
I've had a look into reading the workbook without opening it, but can't get it to work. Most people always suggest using the readonly:=true command. I have found that the WriteResPassword:="password" works fine, as long as someone else doesn't already have it open.. I'm not seeing a sollution..