Remove Macros from Workbook

  • Thread starter Thread starter ostq
  • Start date Start date
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
 
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.
 
Back
Top