![]() ![]() In the Trust Center dialog box, on the File Block Settings tab, in the File Type list, select or deselect the Open check box and the Save check box to prohibit the file type from opening and saving. In the *** Options dialog box, on the Trust Center tab, click the Trust Center Settings. On the File tab, click the Options button.ΔΆ. You can change the list of Block Files by selecting or deselecting the file types that the app opens in Protected View. Private Sub WorkbookOpen () Dim hoja As Worksheet For Each hoja In ThisWorkbook.Worksheets hoja.Visible xlSheetVisible Next hoja If > 0 Then ActiveWorkbook.Close savechanges:False Application. The Block Files list in Word, Excel, and PowerPoint contains file types prohibited from opening or saving in Word, Excel, and PowerPoint, respectively. ![]() If you prefer to open these files in the Protected View mode, select the appropriate check box. This is meant to prevent you from opening an potentially infected file downloaded from the. If these files reside on a file share, you have to mark that share/drive/etc as a trusted source in the trust center in the application. I waited several minutes to see what would happen but it still seems to be hung up in the 'opening in protected view' state indefinitely. Not sure why it continues to try and open it in protected view. ![]() Opening items in protected view is a different problem, and the default behavior for Word, Excel, Etc. The excel graphic says 'opening in protected view' but the file never opens. These two additional options control how to open specified files in Excel. By default, Excel activates certain protected view settings. Edit: Forgot to address the Open in protected view.
0 Comments
Leave a Reply. |