Hi There,

Before a user runs a macro I would like to check that they have not opened the actual Template file, I tried using this:

If ActiveWorkbook.FileFormat = xlTemplate Then
but it does not work and I assume its because its only checking for a template and not a macro enabled template.

Does anyone know the code I will need to check this prior to continuing with a macro?

Cheers,
Marcus