If not equal to multiple criteria/worksheets

Need help with the following simple line of code. It runs the macro perfectly for all sheets other than the one stated in the following line:

Please Login or Register  to view this content.

But I need it to exclude more than on sheet, e.g:

Please Login or Register  to view this content.

The code is running in a workbook with approx 200 sheets! And the code needs to search through most of them. Which is why I need to specify the ones I dont need searched as apposed to the ones that do.
But I cant get it to work, all help much appreciated.

Thanks