Enable macros automatically for a workbook

I have an excel file that onatins macros. Upon opening the file, I am
prompted to answer if I want to enable or disable macros. I would like to
ALWAYS enable macros & not be prompted to answer this question. Is there a
way to set this up?

Thank you.
Regards,
Diane

Hi Diane-

Depending on your version of Excel, go to Tools>Macro>Security and select
Low. Please be aware of the risk as described in the dialog box.

Hope this is useful |:>)

"Diane Alsing" wrote:

> I have an excel file that onatins macros. Upon opening the file, I am
> prompted to answer if I want to enable or disable macros. I would like to
> ALWAYS enable macros & not be prompted to answer this question. Is there a
> way to set this up?
>
> Thank you.
> Regards,
> Diane

Great - Thanks.

"CyberTaz" wrote:

> Hi Diane-
>
> Depending on your version of Excel, go to Tools>Macro>Security and select
> Low. Please be aware of the risk as described in the dialog box.
>
> Hope this is useful |:>)
>
> "Diane Alsing" wrote:
>
> > I have an excel file that onatins macros. Upon opening the file, I am
> > prompted to answer if I want to enable or disable macros. I would like to
> > ALWAYS enable macros & not be prompted to answer this question. Is there a
> > way to set this up?
> >
> > Thank you.
> > Regards,
> > Diane

Diane

If workbook just for your own use, see help on "Digital Certificates" and the

Self Cert feature.


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 06:09:04 -0800, Diane Alsing
<[email protected]> wrote:

>I have an excel file that onatins macros. Upon opening the file, I am
>prompted to answer if I want to enable or disable macros. I would like to
>ALWAYS enable macros & not be prompted to answer this question. Is there a
>way to set this up?
>
>Thank you.
>Regards,
>Diane

Thank you

"Gord Dibben" wrote:

> Diane
>
> If workbook just for your own use, see help on "Digital Certificates" and the
>
> Self Cert feature.
>
>
> Gord Dibben Excel MVP
>
> On Wed, 16 Feb 2005 06:09:04 -0800, Diane Alsing
> <[email protected]> wrote:
>
> >I have an excel file that onatins macros. Upon opening the file, I am
> >prompted to answer if I want to enable or disable macros. I would like to
> >ALWAYS enable macros & not be prompted to answer this question. Is there a
> >way to set this up?
> >
> >Thank you.
> >Regards,
> >Diane
>
>