macro to open file in read only

[Dennis Schuessler]

Can you create a macro to open other workbooks in read
only mode. This way even is the file is being modifed by
someone else it will allways open with the macro?

 

[Frank Kabel]

Hi
try something along the lines of:

Workbooks.Open filename:="c:\temp\book.XLS", radonly:=True

 

[Dave Peterson]

radonly:=True
should be:
readonly:=True

(just in case!)