Erase Code

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.

I am getting a object not define error. Can you help?

"Chip Pearson" wrote:

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

You need a reference to the extensibility library. In VBA, go to
the Tools menu, choose References, and scroll down until you find
"Microsoft Visual Basic For Applications Extensibility Object
Library". Put a check next to this item.


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


"Bill" <Bill@discussions.microsoft.com> wrote in message
news:4EF7A306-7580-4184-B7C7-64BC9F534E74@microsoft.com...
>I am getting a object not define error. Can you help?
>
> "Chip Pearson" wrote:
>
>> 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.
>>
>>
>>