Can't Delete Macro

I have one file that prompts me to Enable Macros or Disable Macros every time
I open it. However, when I get the file open and go to Tools -> Macro ->
Macros, there are no macros listed under "This Workbook" or "All Open
Workbooks"...why is Excel giving me this prompt when I open the file and how
can I get rid of it without getting rid of the prompt when there is actually
a macro?

Thanks,
Denise

there is probably a module which could have a macro.

goto <tools><macro><View visual basic> and see if there is a module. if so,
delete the module

"denise" wrote:

> I have one file that prompts me to Enable Macros or Disable Macros every time
> I open it. However, when I get the file open and go to Tools -> Macro ->
> Macros, there are no macros listed under "This Workbook" or "All Open
> Workbooks"...why is Excel giving me this prompt when I open the file and how
> can I get rid of it without getting rid of the prompt when there is actually
> a macro?
>
> Thanks,
> Denise

That was it, thanks a lot!

"bj" wrote:

> there is probably a module which could have a macro.
>
> goto <tools><macro><View visual basic> and see if there is a module. if so,
> delete the module
>
> "denise" wrote:
>
> > I have one file that prompts me to Enable Macros or Disable Macros every time
> > I open it. However, when I get the file open and go to Tools -> Macro ->
> > Macros, there are no macros listed under "This Workbook" or "All Open
> > Workbooks"...why is Excel giving me this prompt when I open the file and how
> > can I get rid of it without getting rid of the prompt when there is actually
> > a macro?
> >
> > Thanks,
> > Denise