title: How can you prevent a boolean value from being reset?
body: <p>Long story short: 360 separate sheets make up this workbook. The first sheet is the &quot;Main Page,&quot; which is opened when the workbook is first opened, and has a userform that pops up containing the instructions for the main page.</p>
  <p>For about 350 of the other sheets, there is a copy &amp; pasted userform which contains instructions for those 350 sheets, which all operate in the same manner.</p>
  <p>Within those 350 userforms, there is a toggle button which, when clicked, flags a public variable as true, which prevents them from popping up again when the sheet is opened.</p>
  <p>I want that toggle button to prevent those userforms from EVER popping up again as long as the button is depressed on one of those pages. How can I go about accomplishing that?</p>
  <pre><code>If sheetOpenned = False Then
  SubPageInstructions.Show
  End If
  sheetOpenned = True
  End Sub
  </code></pre>
  <p>sheetOpenned is the public boolean declared at the top of the page. Is there a way to make this flag as true for EVERY SINGLE page?</p>
  <p>Thanks for your help. I'm new to vba, and I've only got one book read about it so far, so advice is appreciated.</p>
  <p>P.S. I have no idea why my pasted code isn't formatting correctly, but, alas. Apologies.</p>
  <p>EDIT 1: I forgot: The public boolean is reset when the workbook is closed. How can I</p>
  <ol>
  <li>Prevent that from being reset, EVER.</li>
  <li>Prevent the toggle button in my Userforms from being auto toggled to their default value on workbook close</li>
  </ol>