VBA Code dosent run after close & reopen

I have a complicated wooksheet, whereby I have created code to handle
calculations. When I first create this page and test it, everything
works great.
But, as soon as I close and reopen the file, the worksheet doesnt want
to run any code.

Does anyone know why? If you require more info, such as the code, I
can tell you. But it doesnt seem to be relevant to the problem.

Where are you storing your code?

Are you using UDFs or event macros?

What is your security settings set to?

In article <[email protected]>,
[email protected] (Jagdip Singh Ajimal) wrote:

> I have a complicated wooksheet, whereby I have created code to handle
> calculations. When I first create this page and test it, everything
> works great.
> But, as soon as I close and reopen the file, the worksheet doesnt want
> to run any code.
>
> Does anyone know why? If you require more info, such as the code, I
> can tell you. But it doesnt seem to be relevant to the problem.

It turns out it was the macros. I didnt know that the Worksheet's
change event was counted as a macro.
My security settings disabled all macros. As soon as I turned it off,
it started woring correctly.