Email Single Sheet/Don't Update Linked Data

I used Ron Debruin's code for sending single sheets as email attachments, found here:

http://www.rondebruin.nl/mail/folder1/mail5.htm

and found a post on EXCELTIP.com with a possible fix for my problem,

application.displayalerts = false

The issue that I have, is that when I send a single sheet as an email, it has linked data from lists on other pages in the workbook. (which doesn't get mailed)

What I would like to do is prevent the newly created/emailed sheet from checking for updates information.

Does anyone know a way to disable the Update Data Sources popup, without even opening the sheet that I want to disable popup on?

I've tried using the "application.displayalerts = false" in various areas of Ron Debruins code for emailing. I thought, at first, that if I ran that line of code after the new sheet was copied/created, but before it was saved/sent, that the new sheet would be saved with "DisplayAlerts" disabled.

Thanks,

Erik

Hello Erik,

I have added a line (marked in red) to turn off updating the links. If you have any problems, let me know.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Right on, that's it! Thanks a million Leith!

That's where I was putting the:

application.displayalerts = false

so that it would affect each single sheet individually, not the main workbook, but it did nothing noticable.

What does that command toggle on/off?

Hello Erik,

The Application.DisplayAlerts activates a dialog's default button automatically when the dialog is displayed. This is why you don't see it. You should always know what dialogs you expect to encounter when using this code.

For example, if a sheet were accidentally deleted by the user and this set to false, the user would never see the notification that the sheet is about to be deleted and all information on the sheet would be lost.

Sincerely,
Leith Ross

So I guess that line of code was doing me no good. I'm glad I asked.

Thanks again Leith,

Erik