How about:

Application.DisplayAlerts = False

--
Peder Myhre


"matpj" wrote:


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