Hi,
My DB has one main sheet which contains 14 hidden sheets. the main sheet DB has True or False Test condition button and detail button and Inquiry button. Each True/false test button activates its own sheet and display the result and each Details button also has its own sheet which gives details of the candidate and Inquiry button tells what inquiry required. I have put close button on each sheet with clear all condition and activate main sheet. It's works fine when I open single sheet. but when I open couple of sheets (eg: 3tests, 3details,3inquirys sheets so there are 9 sheets open now) "My user requirement is always show two sheets only" that is True/False sheet or Detail sheet or Inquiry sheet with the Main sheet.
Now my question is how to close all sheets when its open with different button.
thanks in advance.
regards,
Heema
