deleting macros

[Guest]

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

 

[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.

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.

 

[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.