Remove Macros from Workbook

[ostq]

How do I remove all traces of macros in a workbook so that
the macro warning doesn't come up when I open it?

Situation:
I have used some simple macros in a large workbook to help
with formatting.

I have now deleted all macros that I created by going to
the listing of macros (alt+f8).

I have saved the workbook under a new name - but I still
get a warning that there are macros in the workbook when I
open it.

Thanks for any suggestions.

Oliver St Quintin

 

[none]

OSQ,

Copy the sheets to a new workbbok.

 

[Bob Kilmer]

From Excel hit Alt+F11 to open the VB Editor. Right-click and Remove plain
'Modules' from the VBAProject for your workbook. Check the Sheet and
ThisWorkbook modules for stray code and delete it. To test, save the
workbook, then close and re-open.

 

[ostq]

Bob:

Thanks very much - works like a charm!

Oliver