For a specific workbook you would have to digitally sign that workbook.

If for use on your own computer only you can use the SelfCert tool that
comes with Office.

If for use on other computers you would have to purchase a digital
signature.

See help on digital certificates or digital ID


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 08:52:01 -0700, sam
wrote:

Is there a way to enable macro automatically? everytime I open a specific
workbook?

Thanks in advance