Can't turn off 'Update Values:' dialog box?

Hello - I have this piece of code which executes all of the actions I'm intending, but halfway through, I am interrupted with the 'Update Values:' dialog box popping up. If I press 'Cancel', the code runs to completion and all expected results are written out. I'd like to prevent this dialog box from popping up, obviously, but I can't seem to prevent it. I did research it and found a suggestion to use 'ThisWorkbook.UpdateLinks = xlUpdateLinksNever' & 'ThisWorkbook.UpdateLinks = xlUpdateLinksAlways' as sort of bookends around formula execution that was supposed to suppress this dialog box from popping up, but regardless of where I put it in my code, it does not work. Is this the right code to use and, if so, where should I put it?

Please Login or Register  to view this content.

Maybe try;

Please Login or Register  to view this content.

That was it - the '.DisplayAlerts' property worked, whereas the '.ScreenUpdating' property I originally had did not. Thank you!