phantom link/macro

[ward376]

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

 

[ward376]

Now I think it may have to do with Lotus Notes; the user said they
were copying/pasting out of attachments (opened on the email server)
into the file in question, including the sheet I sent. I will check
the file out at home and see what happens.

Environment and apps involved - XP Pro/Office Pro 2003/Lotus Notes 6.5

Still stumped on why the brand new file with only values and formats
pasted in and no vba I can find also has an issue. ALSO - now the
message is back to "blah.xls cannot be found" instead of "macro blah
can't be found" in the newly created file. I should also mention that
when I was getting the macro can't be found message, the path was to
the email server. The file can't be found message only mentions the
file name.

Thanks!
Cliff Edwards

 

[JLGWhiz]

And no macro shows in the dialog box when you Tools>Macro>Macros?

 

[ward376]

None in the workbook, only my personal.

Cliff Edwards

 

[Ron de Bruin]

Hi ward376

If you want you can send me the workbook private then i look at it today or tomorrow

 

[ward376]

Thanks for the tips Ron, the.xlb file was the cuplrit. It took a
couple tries to get rid of it, or maybe it was getting corrupted/
bloated again immediately.

Still don't know specifically what caused it, although I believe the
copying and pasting between files open on the email server and files
on the user's local disk has something to do with it. If anyone has
any answers or ideas, please share.

FYI if anyone is interested - it wasn't just this file that was having
the issue, it was Excel itself. I should have checked that before
posting. This explains why the new file with just values and formats
pasted in had the same issue.(duh) Don't you love it when things go
wrong late on Friday afternoon?

Thanks!
Cliff Edwards