stop excel displaying open as read only box when opening a file

When I open a certain file I get the window saying abcfile.xls is reserved by john smith. Enter password for write access or open as read only.

I already have Application Display Alerts = false in the vba code.

so, how do I stop the window from showing and the file to open as read only without having to press 'Read Only'

Thanks
JagwarmanAsked:
Who is Participating?
 
[ fanpages ]IT Services ConsultantCommented:
Hi,

There is a 'ReadOnly' parameter for the Open Method that you will need to specify as True if a Write-Access password is set on the workbook file you wish to open without being prompted:

Workbooks.Open Filename:= abcfile.xls", ReadOnly:=True
0
 
web_trackerComputer Service TechnicianCommented:
You get the original creator of the file to remove the security settings of the file to give everyone the ability to make changes to the file. Right now it is securely locked by the file creator, who is the only one able to make changes to the file.
0
 
JagwarmanAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.