Yes, that is correct. I missed that you hadn't used App first time, but when
I saw that you noticed I assumed you were sorted, so didn't respond anymore.

Regards

Bob

"ex1302" wrote in
message ...

It won't work until you open the add-in next time, as the application
events
are not initialised. You could run Workbook_Open manually as an
alternative.
You are aware you are dong it on the SelectChange event aren't you.


Bob,

I tried opening and closing the Workbook but the original
Workbook_SheetChange event still didnt work, it only seemed to work
when i changed it to App__SheetChange. Is this correct?


"You are aware you are dong it on the SelectChange event aren't you"
What do you mean?

Regards,

Andy


--
ex1302
------------------------------------------------------------------------
ex1302's Profile:
http://www.excelforum.com/member.php...o&userid=25217
View this thread: http://www.excelforum.com/showthread...hreadid=387079