Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not able to KEEP Macro Security Level At Minimum | Excel Discussion (Misc queries) | |||
set macro security level through VBA | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Detecting Macro Security Level | Excel Programming | |||
Using VBA to change macro security level | Excel Programming |