I don't want to remove the virus protection by not giving people the
option to open a workbook with macros disabled but is it possible to
refuse to open a workbook if macros are disabled ?

I hope that makes sense :o)