I have an Excel workbook that links to other excel workbooks, links to
MS access queries and contains macros that update other workbooks.
When you open this workbook, there are several prompts that a user has
to go through before viewing the data (Enable/Disable macros, Update
Links, Enable/Disable Auto Refresh, Password protected). What is the
easiest way to programatically answer all of the prompts. Only a few
users actually know the password to update the data. My goal is for
the majority of users to open an Excel document and see updated data
(coming from other Excel and Access sources).