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.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46975

"oberon.black"

wrote in message
news:oberon.black.1vqmud_1127354725.1427@excelforu m-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

You could always go to ToolsMacroSecurity 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


--
carlito_1985
------------------------------------------------------------------------
carlito_1985's Profile: http://www.excelforum.com/member.php...o&userid=21390
View this thread: http://www.excelforum.com/showthread...hreadid=469750