See www.cpearson.com/excel/vbe.htm


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


"Bill" <Bill@discussions.microsoft.com> wrote in message
news:6108BB86-E61E-4CA7-94F3-31E1AF046074@microsoft.com...
>I have a spreadsheet that runs code when it opens to populate
>the data. I
> need it to automatically erase the code once complete so that
> when I save the
> workbook with a new name; the code does not rerun when
> management opens the
> workbook to view the data.