Is your new document based on the same template as the first. The template is the document that holds the code. If your new document is not based on the same template then there won't be any code to call.

You should also have a look at AutoOpen.