Skipping over certain sheets in a For Each loop

[NicholasL]

Previously I had been shown a trick to delete all unprotected cells in my workbook.
The problem is, I want to to skip over a certain sheet, can I skip over a certain sheet with For Each loops?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Leith Ross]

Hello NicholasL,

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Yes, just add an additional IF test

Please Login or Register  to view this content.

Note. Use the VBA sheet code name rather than the sheet tab name in case someone should change the tab name.

[NicholasL]

Oh, good call!
Thanks, worked great!