Use
open.worksheet("name.xls"),,true

true makes it open read only
false switches off read onl

--
ianrippin

-----------------------------------------------------------------------
ianripping's Profile: http://www.excelforum.com/member.php...nfo&userid=320
View this thread: http://www.excelforum.com/showthread.php?threadid=27074