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

OSQ,

Copy the sheets to a new workbbok.

-----Original Message-----
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
.

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.

--
Bob Kilmer


"ostq" wrote in message
...
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

Bob:

Thanks very much - works like a charm!

Oliver

-----Original Message-----
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.

--
Bob Kilmer


"ostq" wrote in message
...
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


.