Automatically Answer Prompts

[leann.stout]

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).

 

[Guest]

Create a dummy workbook that the user opens instead. In the workbook_Open
event, put in code tha, opens the subject workbook using the Workbook_Open
method and closes the dummy workbook.

Look in Excel vba help at the Workbooks_Open method. It takes arguments
that will answer many of the questions the user is seeing (and they won't be
prompted).