Don´t show Updatelinks prompt and don´t update

K

Kent

I use the code "Activesheet.copy" and newbook=activeworkbook follwed by
activeworkbook.sendMail. The mail recipient always get the updatelinks for
every new book when it opens.
Is it possible to give the newbook code information (maybe in an auto_open
code) during the sendMail-code session, which don´t show the updatelinks
prompt and don´t update it at the mail recipient?
 
T

Tom Ogilvy

Only in the lastest version of Excel (xl2003 has options under Edit=>Links).
for other versions, no.
 
D

Dave Peterson

If you don't want them updated, could you paste special|values before you send
it?
 
T

Tom Ogilvy

Activesheet.copy
' now a copy of the activesheet is the active
' sheet in a new workbook
Activesheet.cells.copy
Activesheet.cells.pasteSpecial xlValues
Activeworkook.SendMail . . .
ActiveWorkbook.Close Savechanges:=False
 
Top