Use the readonly argument in the worksheet.Open method. You won't be
prompted if you provide the answer.

--
Regards,
Tom Ogilvy

"matpj" wrote in
message ...

I have a huge bit of VBA that includes some open worksheet functions.

I need to be able to turn-off or ignore the messages that come up
asking if I want to open the file as read only etc.

I want to open all files as read only.


any ideas?


--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=483117