View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peder Myhre Peder Myhre is offline
external usenet poster
 
Posts: 4
Default Turning off alerts in VBA

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