Thread: HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
  
Posts: 324
Default HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OP
Workbooks.Open ("MyWorkbook.xls"), False
'Should do the trick.
--
Best wishes,

Jim


"CAPTGNVR" wrote:

DEAR ALL
I have put the code in VB --Application.AskToUpdateLinks = False--.
Now annoying thing is the message to update the links doest come but
this annoying windows showing the linked files props up. Since I have
four to five persons sheet linked, i have to click cancel four times.
How to handle this pls in VB on worksheet open code.


Reply With QuoteReply With Quote