Turning off alerts in VBA

[matpj]

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?

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

"matpj" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Peder Myhre]

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
>
>