Open Excel file as Read Only with code,

[yogendra joshi]

You can use Open Method with optional parameter ReadOnly = True

See following code

Sub open_Read_Only()
Workbooks.Open Filename:="D:/test.xls", ReadOnly:=True
End Sub

Hope this helps

~Yogendra

 

[Guest]

thanks alot of the response.
Okay one more question
Can I make a file read only with code
and can I can code enter a password for a workbook

Thanks Again for all your help

Jason