Seems you got it right.
The private procedures can be private, since they are only called by other procedures in the same module.
I don't know about office 2007, but in office 2003, it was possible to convert a project like this into an add-in, which can then always be available, whenever the add-in is loaded.