Trevor - I have replicated the scenario, & Yes, your
solution below does work.

After I had sent my original reply, I realized it
wasn't "File - Delete". I get the same result as the
Project Rxplorer technique by...

"Alt-F11" - "File - Remove Module1." Then...
Do you want to export Module1 before removing it?

Thank you again, Bob

-----Original Message-----
Bob

no, not file delete ... close, no prize. In the Project
Explorer Window
(Ctrl-R if you can't see it) you'll see your project.
Click the plus signs
until you can see Module1 (or whatever). Right click on
the module and
choose "Remove Modulex"...like we said ;-)

Regards

Trevor


"Bob Barnes" wrote in message
...
Gentlemen (Ed & Trevor) - Thank you.

I have not been able to Post a Reply to both Ed &
Trevor,
but "Alt-F11" gets me into the VBE. Then File ...
Delete..
say "No" to copy somewhere else.

-----Original Message-----
Bob


you need to delete the empty module. Press Ctrl-F11 to
open the VBE. Right
click on the module and choose to Remove the Module.
Say
no to saving the
Module.

Regards

Trevor


"Bob Barnes" wrote in message
...
I am an Access developer automating Access data to
Excel.

I recorded a macro in Excel to get the appropropiate
code
to use within Access. I then deleted the code.

But now opening the Excel file gives the message
about
the file "...contains macros".

How can I ensure that warning does NOT appear when I
open
the file?

TIA - Bob


.



.