Disallowing Update

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Upon opening of a file I get a msg box that prompts users to either update of
not update the file. I would like to insert code to answer this question to
"not update" thus removing the popup menu from the user altogether. Through
code, how would I do this?
 
Define update. Are we talking about queries, links to other spread sheets, ...
 
Jim, Specifically I mean that there is a pop up box that gives me the choice
to either "update" links, "don't update" links or "help". I don't want any
of the users to accidently click "update" links or even, out of curiosity
click "update" links. I want this choice totally taken out of their hands by
having the code click "don't update". Am I describing this correctly?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro brfore close 7
Disable update links prompt 5
Best tool to recover PST files in 2026 1
Toggling save warning message on or off 9
disallowing insertion of rows 4
Word VBA to update cross-referencing 0
Windows Update 0
Disallow sorting of data. 2

Back
Top