Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros

Quintin wrote:

I've got the same problem.

I've delete every macro and line of VB code I can find in all 12 sheets in
the workbook. I save the workbook and close it. When I re-open the workbook,
I get prompted to enable macros again.

What could be causing it/where could there still be macros I've missed?

Quintin

"Jim Thomlinson" wrote:

When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of
the worksheets or ThisWorkbook.
--
HTH...

Jim Thomlinson


"Bodyshopman" wrote:


-turn off macro warning window when all macros are deleted-
bodyshopman

--

Dave Peterson