Visual Basic and Excel Addin

[sunil]

I have created an addin in Excel and set the load
behavior as startup.

When I open Excel and try to type something in the
worksheet I receive a 438 error, object property not set.

This of renders the addin useless.

Then using the COM Addin menu from within excel, I unload
and then reload the addin.

Then everything seems to work fine.

Any suggestions.

 

[Davey Fitz]

Hi,
Presumably then, you have code in the SheetChange event or
some similar event. First, some error-handling wouldn't go
amiss here...this is why the addin bombs out. What code do
you have in the above event? Have you debugged it using a
breakpoint? Can you post it?

Dave