Thread: Screen alerts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brettjg Brettjg is offline
external usenet poster
 
Posts: 295
Default Screen alerts

Hello out there, I have some code to open a folder (by following a heperlink
in a cell). For some bizarre reason (and only just started happening
recently) I get a warning that some folders may contain viruses and do I
really want to open this folder? I have to press "OK". Having displayalerts =
false does nothing in this instance. Is there another displayalerts type of
command that will "OK" this automatically please? Regards, Brett

Current code:
Sub A_OPENFOLDER()
Application.DisplayAlerts = False
Range("J50").Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False
Application.DisplayAlerts = True
End Sub