XL97 Open xl file as read only 1

[vaneagle]

Hi,

Is it possible with vba to open an xl workbook as read only when the file itself is not saved as a read only file ?

 

[DrBowes]

Workbooks.Open FileName:="C:\myfile.xls", ReadOnly:=True

Look at the Open Method in help for more info.

 

[vaneagle]

thanks for that DrBowes!!

I had ,

 readonly = true

I missed the colon!!

Have a star!!