Well if I was going to look for a way to suppress the dialog, I would see if
Excel had a registry value that stored the option for showing the updated
linked tables dialog. However, most likely any changes you make to the
registry settings will not take affect until the next time you open Excel.
And for my $0.02, I think it's bad programming to change someones global
settings without changing them back.

My response was to populate the data with your own macro when the user opens
it, this means you do not use a linked sheet and therefore will not get any
dialog promps. Then using the save event write the data back to the
database. You would have to do a lot of data validation so this is no small
task if you are dealing with lots of data.
Paul D

"Gordon" wrote in message
...
: Hi...
:
: Is there code for not showing dialogue boixes or something like that?
:
: "PaulD" wrote:
:
: How much data are you talking? You could write you own code using
events to
: read / write to the database so there would be no prompting.
: Paul D
:
: "Gordon" wrote in message
: ...
: : Hi Dave...
: :
: : Neither of these sit well with what I'm trying to do. I need a bigger
: stick
: : to sort this one out so that every user on any machine will never be
: asked. I
: : haven't given up hope yet!
: :
: : Thanks
: :
: : Gordon...
: :
: : "Dave Peterson" wrote:
: :
: : Saved from a previous post:
: :
: : You can toggle the setting (user by user, though) via:
: :
: : Tools|Options|Edit Tab.
: : There's a checkmark for "ask to update automatic links"
: :
: : But this means that you suppress the question--the links still get
: updated.
: :
: : This setting is for the individual user--and affects all their
: workbooks.
: :
: : If you want more control:
: : Try creating a dummy workbook whose only purpose is to open the
original
: : workbook with links updated:
: :
: : Kind of like:
: :
: : Option Explicit
: : Sub auto_open()
: : Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
: UpdateLinks:=1
: : ThisWorkbook.Close savechanges:=False
: : End Sub
: :
: : Then you open the dummy workbook and the links will be refreshed.
: : (read about that UpdateLinks argument in VBA's help.)
: :
: : Gordon wrote:
: :
: : Hi.
: :
: : Users of my spreadsheet are opening the file are being asked
whether
: they
: : want to update links or edit links. I want this box not to appear.
: I've been
: : into options but these rules vary from machine to machine. I need
some
: code
: : that will absoloutley not allow this box or options to show.
: :
: : I'm eternally grateful to any genius who kindly responds with an
: equally
: : genius answer...
: :
: : Thanks
: :
: : Gordon
: :
: : --
: :
: : Dave Peterson
: :
:
:
: