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" wrote in
message ...

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