VBA adding a cls module to another workbook

Hello you wonderful people.

I am trying to create a module that will add a worksheet change event in another workbook and it is driving me completely insane and I am unsure what I am missing as it works one moment and then doesn't at all.

Code is below.

Please Login or Register  to view this content.

When I F8 through the code I can see the event in the sheet1 object but when it is closed and I re-open it is not there.

What am I missing?

I'm taking bits and pieces out and it is becoming apparent it doesn't like the paste as when I remove it seems to be working?

Which is irrelevant as I need to paste the info in to the new workbook

I think I solved it.

If anyone is interested I ended up saving the file at the beginning and then instead of using

Please Login or Register  to view this content.

at the end I ended up using

Please Login or Register  to view this content.