Macro statement when opening file, but no macro

[Robert Smith]

Hi folks,

I have a few workbooks which when opening, includes a message whether I want
to enable or disable macros, yet there are no macros associated with the
file. I've gone into VBE to try to remove the macro, but no macros show up.
Any clue on what to do to remove the macro?

TIA,

Bob

 

[Norman Jones]

Hi Bob,

See Debra Dalgleish at:

All of a sudden, when I open the file, it asks if I
want to "Enable or Disable a Macro". There are
no macros in this workbook.
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Robert Smith]

Thanks Norman. Worked like a charm ... save for having to scroll through
40-60 worksheets in 4 different workbooks. Lots of work, but it worked.

Regards,

Bob

 

[Norman Jones]

Hi Robert,

'-----------------
Thanks Norman. Worked like a charm ... save for having to scroll through
40-60 worksheets in 4 different workbooks. Lots of work, but it worked.
'-----------------

I am glad that you have resolved your problem.

However, had the extent of your problem been apparent,
I would have referred you to Chip Pearson at:

Deleting All VBA Code In A Project
http://www.cpearson.com/excel/vbe.htm#DeleteAllVBA

and I would have suggested code to loop through the
required workbooks.