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 u
asking if I want to open the file as read only etc.

I want to open all files as read only.


any ideas

--
matp
-----------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=48311

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

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