Remove Macros from Workbook

O

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top