title: Is there a way to enable the macro code upon clicking on the save icon or File -> save in excel
body: <p>I am trying to validate some form in excel with vb code and when the user clicks on save icon, the vb code is not validating and allowing to save the form without required fields. Also when the user tries to save the file via the <code>File -&gt; Save</code> option, the form validation is not working.</p>
  
  <p><strong>For example:</strong> Prompting the user to fill the required fields.</p>
  
  <p>Any suggestions for this problem?</p>
  
  <p>It is working upon keyboard <code>Ctrl + S</code> option where I specified the settings in the Developer -> Macros options, but not working with the save icon or <code>File-&gt; Save</code> option.</p>