Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress "Disable/Enable Macros" and Query Refresh dialog on open
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress "Disable/Enable Macros" and Query Refresh dialog on open
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop the popup "Enable/Disable Automatic Refresh"? | Excel Discussion (Misc queries) | |||
How do i disable/enable "Worksheet Move or copy" option? | Excel Worksheet Functions | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
How to disable annoying "Enable Macro" popup | Excel Programming | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming |