View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Don´t show Updatelinks prompt and don´t update

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

--
Regards,
Tom Ogilvy

"Kent" wrote in message
...
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?