Only by telling the user what to do.

This is a security measure that wouldn't be too secure if you could bypass it.

Sharon wrote:

Hi
I have a workbook that opens to a home screen with buttons allowing the user
to select which pivots should update and then displays the relevant sheets.
When the workbook is opened it prompts with the Security dialog and the query
refresh dialog. Is there any way of turning them off and then back on again
when the workbook is closed? Thanks.
--
Sharon

--

Dave Peterson