I have 20 worksheets. I need to hide those worksheets by macro according to a value in its own specific worksheet. For example,0=hide worksheet, 1=do not hide worksheet:
Worksheet 1, fieldA1=0 --> hide worksheet 1
Worksheet 2, fieldA1=1 --> do not hide Worksheet 1
Worksheet 3, fieldA1=1 --> do not hide Worksheet 3
Worksheet 4, fieldA1=0 --> hide worksheet 4
etc.
Worksheet 1, fieldA1=0 --> hide worksheet 1
Worksheet 2, fieldA1=1 --> do not hide Worksheet 1
Worksheet 3, fieldA1=1 --> do not hide Worksheet 3
Worksheet 4, fieldA1=0 --> hide worksheet 4
etc.