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