title: VBA Code in Worksheet Won't Run on Other Computer Until Another Macro Runs
body: <p>I have a worksheet that is supposed to do a handful of things depending on what cells are changed. The code works perfectly for me, but when I send the document to someone else, the code inside the worksheet isn't activating at all. I tested by putting breaks in at the top of the code and it just doesn't call the code on the new computer.</p>
  
  <p>If I hit a button below (creates a new sheet) and then go back, it starts working. If the user gets it working (using the button method above), saves the document, and goes back in, it still works. The issue is getting the code behind the sheet to start running immediately.</p>
  
  <p>Things I've tried:
  1. I added a setup/instructions tab that required a checkbox and button press to unhide the setup tab. Did not fix this problem.
  2. I hid everything on the setup tab except for a single "begin" button that unhides all of the objects and text on the form. Did not work.</p>
  
  <p>Some of the code sitting in the Setup tab:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  ActiveSheet.Unprotect
  
  If Not Intersect(Target, Range("D2")) Is Nothing Then
  
  Call UpdateName
  
  End If
  </code></pre>
  
  <p>Again, the code works perfectly for me, and if the user experiencing this issue uses one of the bigger macros, it fixes the problem.</p>