I have a multiple sheet workbook in which certain items are assigned a code
of from a to g. Each of those items then has 2 other sheets associated with
it. How can i make a macro look up the code result, and then close all of the
sheets not needed.

For example, if the result is A, sheets 1 and 7 need to be open, B sheets 2
and 8, etc. There are also some sheets that stay open no matter what.

Thanks for any help.

Bill