Call WB.SaveCopyAs every so often, overwriting the previous file and marking
it Read-Only.
If you are looking for something more like database Replication, use a DB
product instead.

NickHK

"zerosleep" wrote in
message ...

make an excel file somewhere else that is exactly the same as the one I
have, but read only for everyone else. anyway to do this at the
workbook level? I know how to do it at the cell level.

once again, many thanks for all the help.


--
zerosleep
------------------------------------------------------------------------
zerosleep's Profile:
http://www.excelforum.com/member.php...o&userid=17846
View this thread: http://www.excelforum.com/showthread...hreadid=570037