title: "Cannot run the macro (...). The macro may not be available in this workbook or all macros may be disabled."
body: <p>I need some help regarding the "Cannot run the macro (...). The macro may not be available in this workbook or all macros may be disabled.". I have tried the most common suggestions like enabling macros &amp; compiling the project but it does not help.</p>
  
  <p>Short introduction:</p>
  
  <p>I have created a macro which for years run succesfully (let's call it old version) but recently the company upgraded to Office 2016 Professional Plus and it started giving "Subscript out of range error". I have verified and corrected the macro - the reason was quite trivial: new versions of excel create 1 sheet in new workbook while the older ones created 3. The macro tried to do an action in a non existing sheet.</p>
  
  <p>I have saved the changes and sent the macro for testing (new version).</p>
  
  <p>The macro runs at Workbook.Open by showing a simple form, but new version does not show the form on client's computer. Simply nothing happens. I have added a command button, which starts the macro and sent it for testing, but after pressing the button there is again a "Cannot run the macro" message. I thought thet maybe there is an error in the code but after compiling and double checking everything on my PC I could not find any errors. So I have created a new workbook from the scratch with a single line macro: </p>
  
  <pre><code>Sub test() 
  MsgBox "macros enabled"
  End Sub
  </code></pre>
  
  <p>To my surprise running this macro on client's computer also returns the same error message. At this point I thought that there are some security settings that prevent running the macros but a) the old version of the macro is working, b) I have asked the client to download some free example macro from the net and it also works.</p>
  
  <p>Just to add: the new version of the macro (and obviously the MsgBox macro) is working fine on my home PC (Office 2013), my work laptop (Office 2019) and my wife's work laptop (Office 365). The problem is only on client's machine.</p>
  
  <p>Any suggestions will be appreciated.</p>
  
  <p><strong>TL:DR</strong> Macro is working on Office 2019, 2013 and 365 but returns error on Clients Office 2016.</p>