I've always found it irritating that Access opens all of the modules. If you are only working with one then as missingling said it should be the one on top and as long as the code window is maximized no problem. However if you need to work with more than one after a while it can get confusing having all of the modules open.
Before I even work in a module I switch to the VBA Editor and click Ctrl F4 as many time as needed to close them all and then I open the ones I need to work in.
@missinqlinq: How are you going to know what something does without clicking on it? Read the book?