Hi all, I'm using Excel under MS Vista (I think that's Excel 2007?)
and I want to set certain things when a file opens and closes like
sheet protections, hidden tabs, passwords. I've seen it done where a
series of macros are run as soon as the file opens or closes. Can
anyone tell me if there is a specific module name or sub name that
triggers a macro to run automatically on file open or close? or, more
generally, how do I get a macro to run automatically in these cases?

Many thanks!