View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Delete Macro After Running

That's why you will need to use Chips page to write code to go in and delete
you procedure.

Eventually you will need to save the workbook to "seal" your deletion, but
you can't do it in the same sub. The code isn't deleted until it completes.

--
Regards,
Tom Ogilvy


Bill Oertell wrote in message
...
I'm having problems with my Outlook Express, so I'm forced to keep my

posts
much shorter than I'd like. But I didn't mention that the Sub I want to
delete has to run as Private in ThisWorkbook.