Remove the check marks from the three check boxes in Protected View. Select Trust Center Settings, and then select Protected View. In the Ribbon, select File > Options > Trust Center. Please help me to see how read-only way to open the protection of the excel file. To switch off Protected View, change the settings in the Excel Trust Center. Again use Au3 can read excel to get the data. Go to the Protection tab in the Format Cells menu. Workaround 1 Disable the Protected View Settings Open the Excel file throwing the error, go to File and click the Options tab. If you are using excel to manually open this file, you can click excel above the protected view - edit anyway to lift the protection (only need to set once, office will remember that this file is trusted). Press Ctrl 1 or right-click on the sheet and choose the Format Cells option to open the Format Cell menu. The above code has been tested if the open excel file is protected, such as the file is downloaded from the network, or U disk, or above the office version of Office opened 97 office xls file, excel default security options will prompt the excel file Is protected, and can not be modified by default (unless all protection is turned off in the office's options - trust settings). transpose ( $EmpList ) _ArrayDisplay($EmpList). On the Open dialog box, click the arrow next to the Open button. Protected View opens potentially dangerous files, without any security prompts, in a restricted mode, to help minimize harm to your computer. xls ) If Then MsgBox ( 16, 1, "Error" ) With $lastSummaryXls. This can be done by using the Open in Protected View option: 1. $lastSummaryXls = ObjGet (
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |