"Disable Macros"
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
.
|