Fix Highlighted and click on cell to search for specific column

When you double-click a cell is it supposed to collapse everything? If so then try this workbook. BTW, other than manually unhiding the hidden rows, is there some way to unhide them after the double-click?
28974603.xlsm

If i am not mistaken i believe that when i Double click on a cell it will search for that specific word on the "E" column only.

tried the following file, did not work friend

I think the highlighting worked but the double-click didn't. In any case try this version.
28974603a.xlsm

No highlight or double click functioning in my end.

Well it works for me (testing in the first few rows under ToDo) so there are only two things I can think of.

1) Most likely Appliaction.EnableEvents is False from the last time you used the workbook, so got to Visual Basic, type Ctrl+G, and in the Immediate window type Appliaction.EnableEvents = True and press Return. Go back to Excel and try it again.

2) If that doesn't work then maybe you're not looking at the 28974603a.xlsm workbook.

have you checked the video Martin liss it works if you stay on the same part of the file if you start clicking it will disable it please see the video, so that you may see what i am coming from friend.

Here's what I did just now and the results.

Click cell C6 - > highlights
Click cell D16 - > highlights
Click cell E23 - > highlights
Click cell J34 - > highlights
Click cell E41 - > highlights

Some columns don't highlight like "A" and "H"

yes the work it works is that if there is no nothing on a cell it will not highlight, for anything else, highlight function will work.

OK I changed the Worksheet_Change event to highlight even when an empty cell is clicked.
28974603b.xlsm

I have noticed that this worked please check out the video and hopefully you may see a better way to approach it.

***Have it in a way, so that when i click on the refresh button have this in order
-------- Activate right (After having date with Q's updated on the "J" Column) code to refresh/reset or activate those two option Hightlights ROW when clicked once and also when double click have it search for the same word clicked on the "E" Column.

Hopefully this video will work or give you an idea what will be a great way to approach this function.

On YouTube page, on search bar copy and paste the following.
Double click ideas in having it fix

or

Click on this link to be redirected on the YouTube Page
https://www.youtube.com/watch?v=ZcQhYkROs1k&feature=youtu.be

I'm sorry.  I watched the video but I don't understand what you need. In any case is seems like I've fixed this problem so please close this question and ask a new one. When you do please describe in words, step by step

what you do
what happens when you do it
what you want to have happen instead.

Hey martin liss

the title of this question is

Fix Highlighted and click on cell to search for specific column

it is still not fixed if you see the first file that we have started to work i can move and click on buttons customized and still it won't disable those two condition

***Click on cell and if with letter/word on cell highlight row
***Double click to search for the word on the cell click, on the "E" column

both of this function work Martin liss

---but as i said if you click on the DOWN ARROW ORANGE icon located on the left side of the top page it for some reason disable those two condition mentioned above if these condition works when i click on the DOWN ARROW ORANGE Icon located on the left side of the top page this question will be completed.

I just want these two condition to work when i click on the DOWN ARROW ORANGE icon located on the left side of the top page.

Hope this is clear friend.

MARTIN LISS, MARTIN LISS YOU ARE THE MEN! with all do respect friend thanks a mil you did the impossible, again thanks a mil.

Again, glad I was able to help.