Hi Experts,
Can someone help me out. I have a spreadsheet with the code

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Range("B1").Value = "" Then
MsgBox ("s.v.p. je naam invullen!")
End If
End Sub

in ThisWorkbook.

The spreadsheet must be filled in by various colleagues. On opening
the file a dialog about turning the macro's off or on, I know for sure
my colleagus will push the first button and will turn off the macro.
Is there a way to run the macro automatically, so without the dialog.
Altering the secutiry level is nog option, so I guess some additional
VBA will do the trick but I really don't know how.
Can someone help me out?? It would be much appreciated.
Regards,
Anja