View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Barnes[_2_] Bob Barnes[_2_] is offline
external usenet poster
 
Posts: 6
Default "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



.