thisworkbook.open

[james potter]

When I am opening an excel file I get the messagebox to updatelinks or not. Is there a code and what is the code to give excel the answer to not update at startup? I think this code needs to be placed by private sub workbook open. I have seen some answers but they all are opening another file when there is already one open.

For example

Workbook.open (filename), updatelinks
Workbooks.Open FileNmae:= " ", UpdateLinks:=xlUpdateLinks

And also what is the code for update the links of the activeworkbook.
Thanks for all help so far.

 

[Oaktree]

Which version of Excel are you using?

Try going to edit --> links --> startup prompt if that option is available to your version.

 

[Joe Was]

"Don't ask whether to update links when I open any workbook, and update links automatically:"

For the current user only, and affects every workbook opened. Other users of the workbook are not affected on shared workbooks. This option also affects the links to other programs.

On the Tools menu, click Options, and then click the Edit tab.

Clear the Ask to update automatic links check box.
If the box is cleared, the links are automatically updated, and no prompt is displayed.



"Don't ask to update links for this workbook, and let me control whether links are updated:"

Warning: This option affects all users of the workbook. If you choose to not update links, and not to prompt the users about it, users of the workbook will not know the data is out of date!

On Edit menu, click Links.

Click Startup Prompt.

Select the option you want.

Note: You will still be notified if there are any broken links.

 

[Richard Schollar]

To add to what Oaktree has said, I don't believe you can disable it via Workbook_Open, as the prompt executes before the event. So Oaktree's solution is the one to go for (if possible).

Richard

 

[james potter]

I see the problem. I will try a different method to tackle this problem.
Thank you all for your replies.