Originally Posted by gmaxey

You can't.

Users can set their own security settings to allow this but that is not a sound security practice. Users and also created trusted file locations and place file with VB procedures in those trusted location. A security prompt does not appear when files are opened from trusted locations.