Sir Chip,

Thank you for the rapid response. Regreatfully, when I
visit the URL you provided all I get is a nice header
and...

<table border="0" wid

I'll try again later.
Again, may I extend my appreciation for your support?

Earle, Data Troll


-----Original Message-----
Earle,

See the "Deleting All VBA Code In A Project" section at
http://www.cpearson.com/excel/vbe.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Earle" wrote in message
...
Greetings,

Does anyone have macro/VBA code that will find all
Macros
and all user-added Functions, and delete them enmasse?

This code does pass the Compile test, but always returns
Zero as Help says the various properties/methods
of .Modules is hidden and not available:
Dim intVBA As Integer
intVBA = ActiveWorkbook.Modules.Count

I find it a royal pain in the mouse to have to delete
Macros and user-Functions one at a time. These are all
preparation/formatting/processing macros/functions and
are
not needed once the workbook is in the hands of users.

And it would be really neat if the KillMacros macro
would
delete itself as the last thing it does.

Regards to All


.