LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alerts Mark Excel Discussion (Misc queries) 2 September 9th 09 03:01 PM
Inputbox Location on Screen. Can you code it to popup lower on the screen ? Corey Excel Programming 3 December 13th 06 11:33 PM
alerts gambit Excel Worksheet Functions 3 August 22nd 06 04:02 PM
alerts peter Excel Programming 0 January 25th 05 12:52 AM
How to copy data from excel to power point screen by screen? luvgreen[_3_] Excel Programming 0 April 9th 04 03:51 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"