Can't open my workbook with the vba code window opening

Good Afternoon to all:
I have a 2010 workbook with code with all sheets protected AND the code protected. This workbook will be distributed to a number of people who are not familiar at all with VBA. My problem is that this workbook opens on the VBA window every time it is opened. Every time. I want the workbook to open on the sheet that was active at the last saving/closing and not on the code window. I don't want the code window to open at all. How do I do this or how can I fix the problem? Thanks for your time. Bob

Jeff Thank you for your prompt reply. One thing that I forgot to say was both sheets open at the same time. I have two monitors and the active worksheet opens on one monitor and the vba code sheet opens on the other. When I sent this out to my son's (He's the one I'm helping) cohorts they open the file and the vba code window opens on top of the worksheet.
Since they like to play around I don't want the vba code window to open at all and was hoping that I was doing something wrong and it would be a simple fix to have it not show up.
My second choice was to get some code to keep it from opening at all or possibly upon the workbook opening, have some vba code to automatically close it.
I did enable the VBAProject Properties and have it password protected, but I'd rather not give them the temptation. Bob

Originally Posted by jeffreybrown

Honestly I have never experienced the code window and the excel sheet both opening at the same time.

I also have two monitors and every time I open Excel I have to select Alt + F11 to open the VBE.
On any other worksheet that I have this is true, but not on this one and there is no code that we can find where we call this window up.

Even if the VBE did not open (which you said is protected already), what would stop them from selecting Alt + F11 and opening it?
I don't want to waive a piece of candy in front of them, and if they use the Alt + F11 they still require a password.

I can ask the real Excel Guru's for some further assistance if necessary.

If you would I would appreciate it.
I have this as a 2003 worksheet and it's saved in .xls format. It opens the same in a 2003 or 2010 excel program and that's why I thinks it's something
peculiar with this workbook (I have about 5 sheets in it) but am at a loss to figure out what.
Thanks
Bob Reynolds

Gladly, It has been cleaned and no data exists in it, but the problem still exists. Thank you in advance for the help.
Bob Reynolds

AS an explanation. This workbook is set up to import numerous worksheets that others complete. It selects data and pastes it into the various cells and then does a sort and count on the Utility Sheet. It takes data from the Historical Data sheet and puts it into the fat-crit-hr sheet and labels it ytd last ytd last month and last month last year, giving a complete report of the stats. If you don't mind please email me privately to get the password which is the same for all sheets. Thanks again

rjr1040 is what you're looking for all pages