macro's

[LuvExcel130]

hi Does anyone know about security levels? I don't understand why I can create macro's in Excel but I need to turn the security level to low in order for it to work. Why is it potentially harmful to my computer to have a macro that I created in Excel?

 

[shg]

You should never, ever set your security level to Low. Five lines of malicious code can clean your computer's clock.

Set it to disable macros with notification, so that you can enable them if they are from a trusted source. If you don't want to be prompted to enable your own macros, sign the project and trust yourself as a publisher.

 

[LuvExcel130]

Thanks a lot!! So how would I go about signing the project and trust yourself as a publisher?

 

[shg]

I just realized that this is posted in the Lounge. How about asking your question in the forum?

 

[Joe4]

I moved it to the Excel forum for you.

I agree with shg, NEVER set your Security Level to Low.

Here is a link that describes how you can create a Self-Cert sign you can sign your VBA projects. I use it all the time, and it works well. http://www.mrexcel.com/forum/showthread.php?t=110793

You could also set "Trusted Locations" on your computer, that tells it that any files stored in a specific file directory are safe to run. http://office.microsoft.com/en-us/e...sted-location-for-your-files-HA010354311.aspx