VBA Code dosent run after close & reopen

  • Thread starter Thread starter Jagdip Singh Ajimal
  • Start date 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.
 
Where are you storing your code?

Are you using UDFs or event macros?

What is your security settings set to?
 
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.
 
Back
Top