title: how to resolve ambigous name detected error in excel
body: <p>I have written macro which saves current workbook after every ten second,</p>
  <pre><code>    Option Explicit
      
      Public ONTIMER_S As Date
  
  Public Sub SaveBook()
      ThisWorkbook.Save
      
      ONTIMER_S = Now() + TimeValue(&quot;00:00:10&quot;)
      Application.OnTime ONTIMER_S, &quot;SaveBook&quot;
      
  End Sub
  </code></pre>
  <p>this works fine for one workbook, I want to run this macro on multiple workbooks, when I try to add this macro to any other workbook I get error &quot; ambigous name detected Savebook &quot;</p>
  <p>Is there any way to run this macro on multiple workbooks at same time, either by writing this macro to each workbook, or somehow running this macro on multiple workbooks</p>