How to change Macro security level very high to low...

A

areddy

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
+-------------------------------------------------------------------
 
H

Hari Prasadh

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
 
P

Patrick Molloy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change Macro security level very high to low... 1
Set macro security level to 'low level' on opening a certain workbook. 2
Macro-Security level value 3
Unable to set low macro security level excel 2003 4
Return Excel's current security setting 2
My Excel macros won't run any more, even Low security 0
Changing Macro Security settings does not work 1
how can i hange the macro security lavel on ms2007 2

Top