Suppress "Disable/Enable Macros" and Query Refresh dialog on open

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

The only way to suppress the security warning to enable macros is to set the
security to low. There is no way to do this through code as viruses would
just exploit this for their own fiendish purposes. The user can set it to low
but I don't recommend it. In short the answer is no...
--
HTH...

Jim Thomlinson


"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

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