Macros stop working in one worksheet, but contine to work in an earlier worksheet version (?)

[Tanner_2004]

Has this ever happened to you. You are using a spreadsheet and you execute a macro(s) and a message box appears telling you that it can't find the macro or macros may be disabled? This doesn'thappen toall of he macros, just a few.


I then returned to an earlier version (where the macros that aren't working in the new version still work in the old). I coped them from old version worksheet to the new version worksheet and they work fine!

Any one else had this happed and know why?
And how to resolve?

Thank you.

I am using 2007

 

[jamtay317]

https://www.youtube.com/watch?v=ty-zU0Po4ks

 

[Tanner_2004]

Thank you. I watched it. I wound-up copying macros to a new modules and it worked. But I will explore Bill's advice too. Thanks!