SelectionChange not working

[Oberon70]

Hi,

Thanks for all the help I have been getting. The help is helping me automate a few process, but I also to understand VBA better. Therefore, I starting a course and part of the course is using Worksheet Selection Change.

The thing is it isn't working.

Please Login or Register  to view this content.

Have I maybe turned of something in excel? by code? Any else have this problem and how did you fix it?

There is no issue with the code, but nothing happens when I clean on any of the cells in sheet2.

[davesexcel]

Here is an additional thread on worksheet events.

https://www.excelforum.com/tips-and-...et-events.html

[TMS]

What is it you are expecting to happen? Worksheet Selection Change event handler fires when you select a cell on the sheet, not another sheet.

And there's no point enabling events at the beginning of the routine. If event handling wasn't enabled, you would not have got into the routine anyway.

And, if the routine is in sheet2, it wouldn't change anything.

Very confused. Please clarify.