Worksheet_selectionChange does NOT trigger

[MattLogue9]

For some reason Worksheet_selectionChange does NOT trigger. I even tried pasting it into a new book and making it run all macros. Is it not supported in 2010?

Please Login or Register  to view this content.

[Arkadi]

If EnableEvents if deactivated for some reason, it will not run. But to be on the safe side, I would start by putting a stop point at the first line of code, and confirming it truly does not trigger. Or add a messagebox to start... does it truly not trigger?

Please Login or Register  to view this content.

Also, this may seem like a dumb question, but the code IS in the correct sheet? I simply don't know how experienced you are... don't mean to be daft asking that. I've seen users put that in a standard module, which of course would not work.

[MattLogue9]

I have it in module and looked for example code showing so... Because the parent function creates a new sheet... So it CANT have code... Unless I figure out to rename them in a series that have this code snippet pasted into .. I
I'll try again...I thinki had used an example ... I'll try again

If EnableEvents if deactivated for some reason, it will not run. But to be on the safe side, I would start by putting a stop point at the first line of code, and confirming it truly does not trigger. Or add a messagebox to start... does it truly not trigger?

Please Login or Register  to view this content.

Also, this may seem like a dumb question, but the code IS in the correct sheet? I simply don't know how experienced you are... don't mean to be daft asking that. I've seen users put that in a standard module, which of course would not work.

[Arkadi]

Yeah if in a regular module that event wont trigger because it isnt an event for that sheet. There are ways to have your code create the event I believe, after the sheet is created. But I'd need your workbook to try and integrate that.