title: Runtime 1004: OnTime _Application failed upon opening excel files enable edit
body: <p>The error only appears if I open other excel workbook that needs to &quot;enable edit&quot; while running my macro.</p>
  <p>Flow:
  Userform.show (modeless) &gt; opens Userform with a timer</p>
  <p>The debugger points to these lines in Userform code:</p>
  <pre><code>Application.OnTime NextRun, &quot;myTimer&quot;
  Application.OnTime NextRun, &quot;myTimer&quot;, , False
  </code></pre>
  <p>I solved this problem by setting the Macro Security to:</p>
  <ul>
  <li>Enable all macros</li>
  <li>Uncheck trust access to the VBA...</li>
  <li>Uncheck ALL under Protected View tab</li>
  </ul>
  <p>But I need a solution that doesn't involve users to change their macro settings.
  Hope my explanation is clear.</p>