Workbook_Change

[Taemex]

I'm having trouble getting this to work. I open Sheet1 and put in the following code:

Please Login or Register  to view this content.

When cell an12 is clicked, Data Validation gives a list of options which the user can then select from T, S, M, L, or H. When I change this to Sub Something() and run Something()... it works fine. I have other code that runs with Worksheet_Change in other documents that also runs fine. So, I assume I coded something wrong in how it's identified by Excel. Any help much appreciated.

[Winon]

Hello Taemex,

You could try it as per the attached WorkBook.

Also see the "Please consider" note at the bottom of this post.

[Taemex]

On your worksheet, it's working exactly as it should, however once again on my workbook, I can only make it work by manually Running your ProtectSheet() sub. For clarity, yes, I did copy the Sheet1 code. Also, I already have Worksheet_Change code other than this. Maybe this is the issue? Here is my current Worksheet_Change code with your code integrated:

Please Login or Register  to view this content.

[Winon]

Hello Taemex,

Thank you for the feedback.

Please try your Code like this:

Please Login or Register  to view this content.

[Taemex]

That was it! And I thank you very much for your help - I will mark as resolved and +1 your rep right after posting this. Quick question though, why did putting that code at the top change the way the code ran? The only thing I can think of is because of the "On Error", if that somehow made a loop with Nevermind that I was unaware of.

[Winon]

Hello Taemex,

The only thing I can think of is because of the "On Error"...

Yes, you are correct!

Thank you for the good Rep.

Happy Coding.