Look at Chip Pearson's page on the VBE
http://www.cpearson.com/excel/vbe.htm
also
http://support.microsoft.com/default...09&Product=xlw
VBA: How To Delete a Sub Procedure After It Runs Once
--
Regards,
Tom Ogilvy
Bill Oertell wrote in message
...
Is there any way to delete a macro after it has run successfully?