+ Reply to Thread
Results 1 to 6 of 6

How to stop this Alert window?

  1. #1
    Forum Contributor
    Join Date
    12-01-2022
    Location
    Rhodes,Greece
    MS-Off Ver
    office 2021
    Posts
    204

    How to stop this Alert window?

    In this spreadsheet i get always a pop up window that notifies me
    that i have some connections that may not be safe.. how to stop this alert window every time i open this sheet please?
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,224

    Re: How to stop this Alert window?

    For obvious reasons, I am not going to open the workbook, but it will be a cse of emoving the connections. Check that formulae, queries and VBA are not pointing to some external file or other.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    12-01-2022
    Location
    Rhodes,Greece
    MS-Off Ver
    office 2021
    Posts
    204

    Re: How to stop this Alert window?

    Hallo and thank you very much for your answer.i dont have any connection(i belive)and i sawmy vba codes.i dont care if i have external connections.i just dont want this alert pop up window
    Last edited by AliGW; 04-20-2024 at 02:32 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,224

    Re: How to stop this Alert window?

    Please don't quote unnecessarily.

    If you have connections and Excel thinks they are unsafe, then you will get the popup. The only other thing is to ensure that it sees them as safe. It's a security feature - I am not sure that you can or even should suppress it.

  5. #5
    Forum Contributor
    Join Date
    12-01-2022
    Location
    Rhodes,Greece
    MS-Off Ver
    office 2021
    Posts
    204

    Re: How to stop this Alert window?

    i found the solution from this site
    i put the link if anyone needs it
    https://www.extendoffice.com/documen...ks-prompt.html
    thank you very much

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,224

    Re: How to stop this Alert window?

    Thanks for sharing.

+ 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. how to stop microsoft sign-in window
    By gabz1989 in forum Excel General
    Replies: 0
    Last Post: 12-01-2022, 06:05 AM
  2. Macro that can Stop/alert user if a Dropdown is not selected while working on a website
    By aryan_vivek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2016, 08:34 AM
  3. Use VBA to stop 'cannot change part of merged cell' alert..
    By igullage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2015, 01:21 PM
  4. adapt VBA code to stop and alert if any cells are blank
    By yachrishere in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-01-2014, 06:52 AM
  5. [SOLVED] How to display the update the link window but then suppress any alert messages later?
    By billj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2014, 09:53 AM
  6. Stop displaying 'link update' alert
    By pedrofogao21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2012, 09:30 AM
  7. Code to get an alert window to answer no
    By mdnghtsnpr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2010, 04:12 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