That warning can't be turned off. If it could, MS would get blamed if
another "Melissa" virus or something similar started making its rounds
again.
The purpose of that warning, annoying as it sometimes is, is to ensure that
the user is sure of what s/he is doing. IMO, the file being on a local
drive doesn't afford any additional security confidence in it.