I know I can always get help here!!

Paul, ok my post does not seem so long anymore :O). You were
correct, it was in fact the new form that was causing the problem. I
can't believe I did not figure it out right away. The error
was 'File not found'. That would have nothing to do with the form
itself if it was being called from the same workbook - and anyway, a
form is not a file.

I added the capability to 'lock' options on the form, this is done
by writing any options checked (via checkboxes)to a txt file when
the "lock" button is pressed; This same file is accessed as part of
the form Initialization event and those checkboxes that are found in
the record are checked on the form's opening.

Yeah, guess who forgot to create the text file on the user's pc??
That's why I was getting the file not found.

I am embarrassed I needed to post to figure this out. *sigh*

=========================================
And, yes Paul, if you have sample code that I can take a look at so
that I can see how you are set up, that would be great. I have been
just picking this up as I go along, so I am unfamiliar with ways of
implementing rolling out of stuff like this. You said you use the
Workbook_Open event to load all the forms and modules - does this
mean that the users are opening a file on the network? How are users
accessing the functionality that you have built?

The form I have created does not need to use any open file for it's
operation - Rather it is used to grab data or open various types of
reports from folders where new versions of these reports are added
daily. It allows users to get the most recent versions or, specific
reports from specific years without having to manually dig thru the
network to do so. They access the form thru a button I added to
their excel toolbar.

On another note, I never thought about this before, but something
you said piqued my interest - You have a form with 30K lines of
code;
1) is there a limit to how much code you can have tied to a form?
2) are there performance issues when you have a form with so many
lines of code (like the file size slowing things down)?