Open Event Error

[gumdrop]

Greets.

I am relatively new to the world of programming for Excel, and am working to learn the basics. I have been going off of a Excel 2003 programming tutorial, from which I have learned a fair amount. Unfortunately, there is one issue I have been unable to find a solution to.

I am trying to get a module to execute as soon as I open this particular excel document. The following code has been written into the "ThisWorkbook" Open Event window as told to do so in the tutorial:

Please Login or Register  to view this content.

The modules I have built are as follows:
Module1
MyFirstMacro
TimeSheets

Every time I open the excel file, instead of executing TimeSheets, I get an error: "Compile Error: Expected variable or procedure, not module."

I have been unable to figure out exactly why this is happening. Any thoughts to help me get through, what I assume is an incredibly basic, hurdle? I would be much obliged!

[shg]

1. Modules don't execute, procedures within them (Subs and Functions) do.

2. You can't have a procedure with the same name as a module.

[gumdrop]

For some reason, though I read this exact same statement earlier trying to troubleshoot this issue, when I read your response and then looked over what I had been doing it became suddenly clear what exactly was happening. Problem solved, moving on from that then.

Edit: Actually, I do know the reason. Specifically mentioning that modules don't execute but rather the procedures do led me immediately to the solution.

[shg]

For future reference, a better title for your thread would have been the exact error message:

Compile Error: Expected variable or procedure, not module