in general code should always be placed in a standard module.
Code behind sheets or other object (userforms for example) is there to
facilitate methods of that object...such as a worksheet event (click, change
and so on)
This is a large subject, and this is just my view.

Excel 2007 allows files to be saved either with or without code...so its not
"compromised" as such, but it may be that the user saved the file without
when it should have been saved with.





"DA" wrote:

Those are the (obvious) places I had already looked. I have now just
solved the mystery. Apparently, the macro code can be on one of the
sheet objects, rather than in a module. I never knew that until now.
Indeed, I found the code there under the object "sheet1". I assume
there is a special reason for one to place the code there, perhaps so
one can easily find where the macro button is. Does that make sense?
Does anyone know a downside to placing it there instead of within a
module?

Thanks
D