Excel VBA modules not working
<p>I'm using Excel 2010.</p>

<p>I added this code to my sheet and it works.</p>

<pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("A1") &gt; 0.5 Then
        MsgBox "Discount too high"
    End If
End Sub
</code></pre>

<p>But I want to create some way where I could create code and share that code across all excel workbooks on our network.</p>

<p>So I made a module and created an add-in and put the code INTO the module of the add-in.</p>

<p><a href="https://i.stack.imgur.com/RbnsE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RbnsE.png" alt="enter image description here"></a></p>

<p>I deleted the code from the sheet since I want the code to be accessible from the module.</p>

<p>I enabled the module.</p>

<p><a href="https://i.stack.imgur.com/Q1tAj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q1tAj.png" alt="enter image description here"></a></p>

<p>And the VBA code doesn't work unless I put the code into the sheet. Please advise how I can just have this code in one file and have that code shared across all excel workbooks on our server.</p>