+ Reply to Thread
Results 1 to 4 of 4

Updating macro to close pop-up windows.

  1. #1
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Updating macro to close pop-up windows.

    Hello All,

    Attached macro that was created for me awhile back that bascially opened files, updated the values on each sheet that were references to other files and then save and close.

    This worked great... until i updated to Office 2013.

    Now with excel 2013 everytime i try to update my files a pop-up comes up
    "This workbook contains links to one more more extrenal sources that could have unsafe"

    Can someone have a look at this macro and add in the command to ignore (or to accept the pop-up) so that I do not manually have to do this?

    Thank you in advance,

    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Updating macro to close pop-up windows.

    Hi Jason

    See this link
    http://stackoverflow.com/questions/1...-links-warning
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: Updating macro to close pop-up windows.

    Quote Originally Posted by jaslake View Post
    Perfect. Works great now.

    Thanks!

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Updating macro to close pop-up windows.

    You're welcome...glad I could help. Thanks for the Rep.

+ 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. [SOLVED] Macro to Close Empty Windows
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-11-2012, 12:44 PM
  2. How to close annoying popup windows with Excel macro?
    By KB7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2012, 10:35 AM
  3. auto close windows
    By omgeokid in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2011, 12:34 PM
  4. Close all Windows?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2006, 09:59 AM
  5. Replies: 1
    Last Post: 02-09-2006, 05:10 PM

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