ProtectedViewWindow.Edit(Object, Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Opens the workbook that is open in the specified Protected View window for editing.
public Microsoft.Office.Interop.Excel.Workbook Edit (object WriteResPassword, object UpdateLinks);
Public Function Edit (Optional WriteResPassword As Object, Optional UpdateLinks As Object) As Workbook
Parameters
- WriteResPassword
- Object
The password required to write to a write-reserved workbook.
- UpdateLinks
- Object
Specifies the way external references (links) in the file, such as the reference to a range in the Budget.xls workbook in the following formula =SUM([Budget.xls]Annual!C10:C25), are updated.
Returns
Returns a Workbook object.
Remarks
If the WriteResPassword
parameter is omitted and the workbook requires a password, the user will be prompted for the password.
If the UpdateLinks
parameter is omitted, the user is prompted to specify how links will be updated. If Excel is opening a file in the WKS, WK1, or WK3 format and the UpdateLinks
argument is 0, no charts are created; otherwise Excel generates charts from the graphs attached to the file.
Avoid using hard-coded passwords in your applications. If a password is required in a procedure, request the password from the user, store it in a variable, and then use the variable in your code.
You can specify one of the values, listed in the following table, in the UpdateLinks
parameter to determine whether external references (links) are updated when the workbook is opened.
0 | External references (links) will not be updated when the workbook is opened. |
3 | External references (links) will be updated when the workbook is opened. |
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기