I have list of sheets names . for each sheet contains color . so waht I want hide any sheet, if the color is not matched as in existed in list for each cell in column A , then should be hidden and if it is matched then should be unhide for each sheet separately based on its own color
sheets.xlsm | |||
---|---|---|---|
A | |||
1 | |||
2 | SHEET1 | ||
3 | PROCESS | ||
4 | OPERATION | ||
5 | DATA | ||
6 | |||
MAIN |