Hi Brian

With code look for ChangeFileAccess in the VBA help

ActiveWorkbook.ChangeFileAccess xlReadOnly


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Brian" wrote in message ...
Hi

How do you set the file as read only.

Br.
Brian