Macros don't open in other computers

[parole]

Hello!
I have question regarding macro enabled templates.
After I create a macro in a template (and save it as macro enabled template) I try to deliver it to my colleagues by email or by USB stick.
Although macro works perfectly on my computer, it completely disappears when I try to upload it to another computer.

Im thinking, maybe the problem is in security level on other peoples computers. Or maybe using the "Disable all micros with notifications" in Macro Security is wrong ??

Microsoft? Anybody? Please HELP!

The code I use is really simple, it needs to sum all numbers above active cell (i.e. TOTAL):

Sub Macro1()
' Macro1 Macro
'
Selection.InsertFormula Formula:="=SUM(ABOVE)", NumberFormat:=""


End Sub

THANKS