Hello all,

I have created an interviewing tool for auto-generating security non-functionals. Analysts sit with a technical SME and ask a series of questions, and the answers are used to output a set of NFRs.

The design of the tool is such that users never need to save the tool, it exports their results into a new file, even PDF if they choose. Because of this, every time the file is opened, all previous data is cleared out, some tabs are hidden, others revealed, and focus set on the "Instructions" page.

I realized recently a potential flaw in this. It may be that one technical SME cannot answer all of the questions, so the analyst may need to "pause" and finish with someone else later. Simply doing a "Save As" won't fix the problem, as their work will be cleared out when they open back up.

I need to figure out how to allow a "Preserve State" Save As while not losing my current code.

What do you think of this approach:
I create a hidden "Pause" tab. When the users click a "Finish Later" button, data gets populated into that tab and a SaveAs dialogue is brought up. I then update my Open Workbook code to check for data in the Pause Tab. If found, the Open Workbook code repopulates the user's inputs, and clears out the data in the Pause Tab.

Thoughts?