I have a workbook with about 200 different worksheets in them. Each of the worksheets has cell N9 as either "Active" or "Inactive" If cell N9 says "Inactive" then I want to color code the tab red and hide the worksheet. There are a few worksheets that would be excluded (template, instructions, user form, master project list, payment status, reference, active projects and completed projects) [8 worksheets total that would be excluded from the macro]
Ideally if N9 changes to "active" I would want it to unhide.
What is the best way to achieve this?
Ideally if N9 changes to "active" I would want it to unhide.
What is the best way to achieve this?