title: Excel Macro during open process
body: <p>Trying to write a macro to turn the multi select on for a slicer when the workbook is opened. The macro works if I run it manually but does nothing when I open the file. Can someone help figure out what is missing?</p>
  <pre><code>Sub Auto_Open()
  
  Sheets(&quot;Field HC Report&quot;).Activate
  
  ActiveSheet.Shapes.Range(Array(&quot;Reporting Country&quot;)).Select
  SendKeys &quot;%s&quot;
  DoEvents
  
  End Sub
  </code></pre>
  <p>Thanks,
  Amy</p>
  <p>UPDATE: Putting it in Workbook_Open() and in the workbook rather than module made it work. Thank you Samuel and Kin! One other question, how would I modify this if my file is password protected to be read only for other users? I would like the macro to run even when users open it as read-only. – Amy</p>