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 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