+ Reply to Thread
Results 1 to 4 of 4

Excel VBA to dismiss Windows Security

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Excel VBA to dismiss Windows Security

    I am getting a "Windows Security Warning" dialog box when I am using the macro below to scrape information off a webpage. Any ideas how to either prevent the dialog box from showing up in the first place or using Sendkeys to click "Yes" when the security warning appears? Thx.

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: Excel VBA to dismiss Windows Security

    Try with:
    Please Login or Register  to view this content.
    at the start of the code.

    And then enable it at the end
    Please Login or Register  to view this content.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Excel VBA to dismiss Windows Security

    Can you post the URL you are having the problem with?
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Excel VBA to dismiss Windows Security

    Tried the DisplayAlerts option with no luck.

    That is a UDF used in conjunction with a macro that I have that retrieves webpage content based on a selection. Macro is below,,

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help, excel keep popping Windows Security Warning
    By Lewis Koh in forum Excel General
    Replies: 9
    Last Post: 02-24-2015, 04:19 AM
  2. Internet Windows Security POPUP
    By Sniper in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2014, 08:09 PM
  3. How to login to Windows Security dialog box
    By kurtmcgill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2014, 04:16 AM
  4. sendkeys windows security pop-up window
    By ljoseph in forum Excel General
    Replies: 0
    Last Post: 11-17-2011, 05:35 PM
  5. Replies: 1
    Last Post: 04-12-2006, 07:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1