opening workbook as read-only or write-enabled

can anyone please help me on this?

how can I use the open.workbook function to open a workbook as read-only or
specifically write-enabled.

any help would be greatly appreciated
thanks

Good morning archiboy

Try this:

Workbooks.Open Filename:="C:\Test.xls", ReadOnly:=True

HTH

DominicB

"archiboy" wrote:

> can anyone please help me on this?
>
> how can I use the open.workbook function to open a workbook as read-only or
> specifically write-enabled.
>
> any help would be greatly appreciated
> thanks