Linked table message in VBA

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

When I open a spreadsheet with linked data I get a message box that asks if
I want to update the data.
How do I disable this message in VBA. I have as series of worksheets that
I am opening and I would like to stop those message boxes from opening.
Thanks
Tom
 
Hmmmm....
I never thought to set that on the spreadsheet itself....I figured that I
would need to do it the most difficult way. I needed to write it in code.
It worked! I just set the option on the worksheet that was open and it took
care of the box.
Thanks David!

Tom

Tom wrote
How do I disable this message in VBA.
Click to expand...

If you always want this to happen, consider unchecking 'Ask to update
automatic links' in Tools|Options|Edit
 
Back
Top