ThisWorkbook Private Sub, two or more subrutines?

Only One with the same name per module sheet or vba as long as it's private
You can add as many If and If Then Else or Intersect commands to accommodate for different conditions.
So If condition this and this and this then do that elseif other conditions then that elseif more conditions elseif etc. and end with End If

You can't have more than one event of same type, or it will cause conflict.

Just use IF statement to change action.

I'm not exactly sure what you are trying to do here. But try...

Please Login or Register  to view this content.

Not functioning.
I have sheets "ED-5" and "List1"
I need inside them after cell click or keyboard arrow select cell, to highlight row between area set in code.

Sorry if bad English, too much Hollywood movies..

Please Login or Register  to view this content.

Sheet "ED-5" = columns between 15-28 and rows 6-2000, any click/select outside this range End Sub
Sheet "List1" = columns between 1-23 and rows 2-1000, any click/select outside this range End Sub
If ActiveSheet.name<>"ED-5" or ActiveSheet.Name<>"List1" please dear EXCEL End SUb.

You code like your english is not that good and I hope I understood it correctly
Try this

Please Login or Register  to view this content.

Have you tried it?

THIS IS IT, THANKS !!!!! But...

Please Login or Register  to view this content.

When i doubleclick outside range, it highlight row inside range anyway. Why?
Single click is fine, but doubleclick, it highlight row even i'm outside that range.

Doubleclick ? No code for double click, that is just Excel or maybe you p;lace some double_click code in the worksheets?
And you do not need Application,Screenupdating for conditional format.
That ALWAYS works, I was wondering why you had that.
You could however add Activesheet.Calculate

I don't know, I don't have the file I can't see it. It has nothing to do with the code I posted.
what have you changed or added?

Without the file or the code ...
Cannot say, is the worksheet protected and are the cells outside the range locked?

Originally Posted by Keebellah

Without the file or the code ...
Cannot say, is the worksheet protected and are the cells outside the range locked?

here filee

I cannot find the code that highlights the range, but it it triggered only when you double click.
Since the VBA is locked I cannot check the references in the Tools menu.
You implemented something that highlights that row but not with the vba code you provided.
When you double click you trigger an event

Here code, first one works, second don't. It's just I don0t know or it can't have name like "Workbook2" to work.

Please Login or Register  to view this content.

First one, works, but when I select(doubleclick or BACKSPACE) cell outside the range, it highlight the same row as i'm inside the range. I don't want that. Please, highlight row only when I'm in range.

First, WorkBook2 is not an Excel expression in these cases.
NO GO

You must integrate is in teh WorkBook_SheetSelectionChange
I explained the reason, I cannot help you