Force Macro Enabled

What code can I add to my workbook to force it to macro enabled.

I hate seeing that damn msg everytime I open my workbook.

Please give me the code and where to put it.

Thank you.

You could always go to Tools>Macro>Security and set it to "low".
Keep in mind it could cause problems if you download any excel sheets with dodgy macros, but this will work at least.
Thanks,
Andy

"oberon.black"
<oberon.black.1vqmud_1127354725.1427@excelforum-nospam.com>
wrote in message
news:oberon.black.1vqmud_1127354725.1427@excelforum-nospam.com..
>
> What code can I add to my workbook to force it to macro enabled.
>
> I hate seeing that damn msg everytime I open my workbook.
>
> Please give me the code and where to put it.
>
> Thank you.
>
>
> --
> oberon.black
>

Hi,

Diditally sign the project and the 'trust' the signature next time you
open excel and it will never bother you again for that workbook.

HTH,

Alan.

The point of making this a user setting is to allow them to choose to run macros
(or not).

If your code could change this setting, then it wouldn't be very effective--and
macros that do very bad things would take advantage of this, too.

If the only workbooks you open are ones you developed, then just turn the
security to low.



"oberon.black" wrote:
>
> What code can I add to my workbook to force it to macro enabled.
>
> I hate seeing that damn msg everytime I open my workbook.
>
> Please give me the code and where to put it.
>
> Thank you.
>
> --
> oberon.black
> ------------------------------------------------------------------------
> oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
> View this thread: http://www.excelforum.com/showthread...hreadid=469750

--

Dave Peterson