How do I enable a macro using vba?

[davin2929]

When I open the workbook with an Auto Run macro in it the first thing that pops up is the disable/enable macro alert. I would like to set the code in the Auto run macro to disable that alert so when I open the workbook the Macro runs without clicking disable or enable macros.

 

[Mark O'Brien]

You can't.

Thinking about it logically, how can you set a macro up to enable macros? For the macro to work, macros would have to be enabled.

This is a security feature to protect people from malicious code.

This question has been discussed several times on this board before. The general consensus is that lowering your security to always enable macros is a bad idea. A slightly better idea is digital signatures, Corticus has a decent description here of how to use these:

http://216.92.17.166/board/viewtopic.php?topic=21566&forum=2

HTH

 

[skadan]

I wondered about this too

Mark is correct though, it can't be done. However, if you have MS Office, install the vba self-cert 'add in' from MS tools option.

You can then create a digital certificate, which when attached to your vba code (in vb editor) will allow your project to bypass security/macro dialogue each time.

Lookup "certificates" in xl & vba help for more info

 

[Mark O'Brien]

On 2002-10-16 16:46, skadan wrote:
I wondered about this too

Mark is correct though, it can't be done. However, if you have MS Office, install the vba self-cert 'add in' from MS tools option.

You can then create a digital certificate, which when attached to your vba code (in vb editor) will allow your project to bypass security/macro dialogue each time.

Lookup "certificates" in xl & vba help for more info

..or just follow that link I posted and follow corticus' procedure.