Hi all,

In Private Sub Workbook_Open() iam writing some code.in that only whe
i open workbook i want to change the status of the macro security leve
very high radio button to low radio button.

is there any code to do this.

please check the screenshot.

please help me on this.

Thanks&Regards,
Amar..

+-------------------------------------------------------------------
|Filename: How to change Macro security level very high to low....doc
|Download: http://www.excelforum.com/attachment.php?postid=3996
+-------------------------------------------------------------------

--
aredd
-----------------------------------------------------------------------
areddy's Profile: http://www.excelforum.com/member.php...fo&userid=2820
View this thread: http://www.excelforum.com/showthread.php?threadid=48271

Amar,

AFAIK there is no code which can tinker with the macro settings as the
purpose of preventing malicious (puportedly) macros from executing would be
defeated.

Thanks a lot,
Hari
India

"areddy" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hi all,
>
> In Private Sub Workbook_Open() iam writing some code.in that only when
> i open workbook i want to change the status of the macro security level
> very high radio button to low radio button.
>
> is there any code to do this.
>
> please check the screenshot.
>
> please help me on this.
>
> Thanks&Regards,
> Amar...
>
>
> +-------------------------------------------------------------------+
> |Filename: How to change Macro security level very high to low....doc|
> |Download: http://www.excelforum.com/attachment.php?postid=3996 |
> +-------------------------------------------------------------------+
>
> --
> areddy
> ------------------------------------------------------------------------
> areddy's Profile:
> http://www.excelforum.com/member.php...o&userid=28204
> View this thread: http://www.excelforum.com/showthread...hreadid=482710
>

Nope. That would allow anybody to write malicious code.. The whole point of
security is to prevent this!!

"areddy" wrote:

>
> Hi all,
>
> In Private Sub Workbook_Open() iam writing some code.in that only when
> i open workbook i want to change the status of the macro security level
> very high radio button to low radio button.
>
> is there any code to do this.
>
> please check the screenshot.
>
> please help me on this.
>
> Thanks&Regards,
> Amar...
>
>
> +-------------------------------------------------------------------+
> |Filename: How to change Macro security level very high to low....doc|
> |Download: http://www.excelforum.com/attachment.php?postid=3996 |
> +-------------------------------------------------------------------+
>
> --
> areddy
> ------------------------------------------------------------------------
> areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204
> View this thread: http://www.excelforum.com/showthread...hreadid=482710
>
>