Inject Code into an external Workbook?

[mobiius]

I have a spreadsheet that makes use of a User Form. On the User Form there is a Save button. It saves one of the sheets as a new workbook.

When I go into the destination folder and manually double click on the saved file, it produces the "This workbook contains links to other data sources" message.

I think I want to use this code to disable the message (but I could be wrong):

Workbooks.Open.UpdateLinks = xlUpdateLinksNever

The question is, how do I include this code in the saved workbook automatically (when the user clicks the save button)??
I don't want to have to manually open the saved workbook and put the code in. I want to do it automatically.
Where would I put this code (or other code that will do the same thing)?

 

[RoryA]

That won't work since the message should occur before your code runs - it's a per machine setting not per workbook.