Hi Ken, even though you were in a hurry, you solved it so now it checks the text in both sheets. Great!

It's getting almost perfect now. The only thing is that the screen keeps flickering. At first you could also see the files opening/closing in the taskbar but I added [VBA]Application.ShowWindowsInTaskbar = False[/VBA] and at the end [VBA]Application.ShowWindowsInTaskbar = True[/VBA] So the sheets with the hits can only be seen at the end of the routine.
Now It would be great if the original sheet would stay in focus and that the opening/closing of the searched sheets would stay in the background. Don't know if that's possible. But now you see every checked sheet opening and closing. I've tried to put [VBA]Application.ScreenUpdating = False[/VBA], but in the end it was all over the routine and the flickering kept on going.

I don't know if the next question should come in a new thread.......do you know a routine that gives a message when people click on the upper right [X] of Excel to tell them to close by clicking on a button in the sheet? So closing by clicking [X] is not possible in this workbook only.


Thanks and regards.