Hi,

When ever I write a piece of code and save & close my worksheet, and
then later open it again, I get a message box saying that macros in
the worksheet have been disabled. How do I get rid of this message box
and consequently avoid the problem of macros getting disabled...?

--deostroll

I would suggest you lower your security settings to medium or digitally sign the
project.


Gord Dibben MS Excel MVP

On Mon, 04 Jun 2007 23:23:13 -0000, deostroll <(E-Mail Removed)> wrote:

>Hi,
>
>When ever I write a piece of code and save & close my worksheet, and
>then later open it again, I get a message box saying that macros in
>the worksheet have been disabled. How do I get rid of this message box
>and consequently avoid the problem of macros getting disabled...?
>
>--deostroll

To add to Gord's response, you can get to security settings through
Tools/Macros/Security.

"deostroll" wrote:

> Hi,
>
> When ever I write a piece of code and save & close my worksheet, and
> then later open it again, I get a message box saying that macros in
> the worksheet have been disabled. How do I get rid of this message box
> and consequently avoid the problem of macros getting disabled...?
>
> --deostroll
>
>