PDA

View Full Version : Solved: open macro security setting dialogue box



wilg
06-22-2011, 02:43 PM
Can someone help me with code on how to prompt the macro setting dialogue box to appear for the user to change the settings? I want it to auto appear not for them to select from the tools menu.

Thanks in advance.

Jan Karel Pieterse
06-22-2011, 11:37 PM
Application.CommandBars("Worksheet menu bar").FindControl(ID:=3627, recursive:=True).Execute

wilg
06-23-2011, 05:29 PM
Perfect. Worked like I wanted. Thanks you.