How do i use VBA script to control macro security level
 

Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

swiftcode,
I hope it is not.

NickHK

"swiftcode" wrote in message
...
Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

Hi SwiftCode,

If you are able to solve this, you will please many an aspiring virus
propagator.


---
Regards,
Norman



"swiftcode" wrote in message
...
Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

There was a post about security settings using registry keys by someone
called Jim Rech, the key was:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

And then you've got level in there

Norman Jones wrote:
Hi SwiftCode,

If you are able to solve this, you will please many an aspiring virus
propagator.


---
Regards,
Norman



"swiftcode" wrote in message
...

Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

Not really. If the virus writer has already got the OP to run his code,
changing macro settings at that point is irrelevant.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Jones" wrote in message
...
Hi SwiftCode,

If you are able to solve this, you will please many an aspiring virus
propagator.


---
Regards,
Norman



"swiftcode" wrote in message
...
Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

Good morning Swiftcode

You cannot control this using VBA - if you could then Microsoft may a
well have not bothered building it in in the first place. On
workaround is to use the SendKeys command, which is a clumsy way o
doing things and can be inaccurate.

Alternatively, set yourself up with a digital certificate or (i
possible) code your project as an add-in. Either of these two way
will prevent the macro warning message from appearing.

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39714

How do i use VBA script to control macro security level
 

Hi David,

Thank you for the information.

---
Regards,
Norman



"David Welch" wrote in message
...
There was a post about security settings using registry keys by someone
called Jim Rech, the key was:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Security

And then you've got level in there

Norman Jones wrote:
Hi SwiftCode,

If you are able to solve this, you will please many an aspiring virus
propagator.


---
Regards,
Norman



"swiftcode" wrote in message
...

Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

Hi Bob,

I read the question from a position of preconceived prejudice and, thus,
overlooked the potentially legitimate utility.


To SwiftCode,

I apologise for applying less thought to your question than required.
Fortunately, David has provided you with constructive advice in his adjacent
post.

---
Regards,
Norman



"Bob Phillips" wrote in message
...
Not really. If the virus writer has already got the OP to run his code,
changing macro settings at that point is irrelevant.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Norman Jones" wrote in message
...
Hi SwiftCode,

If you are able to solve this, you will please many an aspiring virus
propagator.


---
Regards,
Norman



"swiftcode" wrote in message
...
Hi,

I heard that it is possible to control the excel
macro security level using vba scripts,
does anybody have any idea on how to do this?

Thank you in advance

How do i use VBA script to control macro security level
 

Hi All,

Thank you for trying to give me an answer to this query, but first to ally
your doubts about me asking this question, my intentsion was purely out of
curiosity, as i heard it being mentioned by a friend who read it somewhere
before.

The issues of hackers and viruses, and the implications of such a script did
not cross my mind, i merely thought it would be a good idea, so that whenever
i create a spreadsheet with macros for someone, i need not physically go
change the security settings for them everytime. I could simply do it without
the hassle of running around.

Anyway thank you all very much for your feedback and suggestions, it is
greated appreciated. And Norman, don't be sorry, we all learn someting new
everyday, just as i did from all of you today.

Everyone,
have a great weekend.

Rgds
Swiftcode