IF statement for all existing sheets in workbook

I am using the below working code to create sheets based on the values of a range of cells. If a worksheet with the same name already exists, then a new sheet is not created. When a worksheet gets created for the first time, I have the code looking for certain values on each sheet to see if they are "NONE" or 0. If those "NONE" or 0 values exist, then a range on the spreadsheet gets hidden. Here's where I need help: I want the same code that looks for the "NONE" and 0 values to do the same thing on the EXISTING sheets too (not just the newly created sheets). How should I modify my code below to have this evaluated for both new and existing sheets ?

Please Login or Register  to view this content.

Kind regards!

I have attached the workbook below for your reference:

Example Workbook.xlsm

It also would have been helpful if I put the corresponding function used in my prior code:

Please Login or Register  to view this content.

Kind regards!

Well, I spent some time today and figured it out.. pretty easy fix, I just made the macro use the WorksheetExists function instead of focusing on the Worksheets that don't exist. The Sheets(MyCell.Value).Select runs through all the sheets that currently exist with names from MyRange of cells.

Please Login or Register  to view this content.