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

anybody??

Macro is in Excel? Word?

Yes, the security settings on other computers can be an obstacle to your macro. (It is supposed to be.)

In Word, a template with macros will be disabled when it comes from a foreign source even if placed in a trusted location. Even a document with no macros will be locked for editing (opened in protected mode). A message does pop up on my machine with my settings that lets me enable editing and macros in the foreign document.