VBA Code dosent run after close & reopen

  • Thread starter Jagdip Singh Ajimal
  • Start date
J

Jagdip Singh Ajimal

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

JE McGimpsey

Where are you storing your code?

Are you using UDFs or event macros?

What is your security settings set to?
 
J

jsa1981

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