I hope someone has seen something like this before...

Background:
I had this file with automated page setup code. A particular user
insisted on putting it in print preview which was irritating to the
recipients so I put in some code to detect (thanks to this forum)
whether page break preview was selected and notify the user that
setting the page breaks manually was unnecessary.

That all worked fine... then I copied a sheet out of the workbook that
DIDN'T contain that code but contained some other code to insert/
adjust named ranges when the lists were modified (from Contextures)
for another user that just wanted the information in the lists. This
was a very hidden sheet the users never saw. I sent it to the
requesting user but forgot to delete the code in the sheet. The user
inserted that sheet into a workbook that they were working on.

Issue:
Now when you select print preview from the toolbar or File menu in
this user's workbook you get a msgbox with
"'blahblah.xls' cannot be found. Check the spelling of the filename,
and verify that the file location is correct."
You can select page break preview from the page setup dialog though.
(the code I used to detect only looked for commandbar items)

There is no visible code in this user's workbook in any sheets or
objects (they said they never even saw any - this user isn't a vba
user) and I couldn't find any links to other files or any named
ranges, even using Bill Manville's add-in.

So I copy/pastespecial values then formats out of each sheet into a
new workbook. Now the message is "macro 'blahblah' can't be found."
Now I'm stumped. This is a brand new file created on a different
machine and I only pasted values and formats into it.

So - can event driven code be hidden from the vba editor? Maybe our
email system is doing something weird? (grasping at straws here, I
email turnkey xl apps without issues) What am I overlooking?

Thanks!
Cliff Edwards