deleting macros

I

itsme

Is there anyway to delete all macros in a file at one time, instead of picking one and hitting delete and then having to go back in for everyone.

Thanks
 
D

David McRitchie

See Chip Pearson's coding for the VBE (Visual Basic Editor)
http://www.cpearson.com/excel/vbe.htm
there is a macro to do it all for you, much more reliable and faster than trying to do
it manually. If you read about it there you will also know if your would have done it
correctly if trying manually.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

itsme said:
Is there anyway to delete all macros in a file at one time, instead of picking one
Click to expand...
and hitting delete and then having to go back in for everyone.
 
D

Dave Peterson

It kind of sounds like you're deleting macros from the Tools|macro|macros...
dialog.

You can also select the code (from "Sub" to "End Sub") while you're in the VBE
module and just hit the delete key.

If your macros are in the same module and right next to each other, it might be
quicker.

If you don't want that, then alt-F8 is a shortcut to display that
Tools|macro|macros... dialog.
 
Top