Application.FileValidation property (Excel)
Returns or sets how Excel will validate files before opening them. Read/write.
Syntax
expression.FileValidation
expression A variable that represents an Application object.
Return value
Remarks
Files that don't pass validation will be opened in a Protected View window. If you set the FileValidation property, that setting will remain in effect for the entire session that the application is open.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.