Workbook.Protect(Object, 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.
Protects a workbook so that it cannot be modified.
public void Protect (object Password, object Structure, object Windows);
abstract member Protect : obj * obj * obj -> unit
Public Sub Protect (Optional Password As Object, Optional Structure As Object, Optional Windows As Object)
Parameters
- Password
- Object
A case-sensitive password for the workbook. If this argument is omitted, you can unprotect the workbook without using a password. Otherwise, you must specify the password to unprotect the workbook.
- Structure
- Object
true
to protect the structure of the workbook (the relative position of the sheets). The default value is false
.
- Windows
- Object
true
to protect the workbook windows. If this argument is omitted, the windows are not protected.
Remarks
Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords do not mix these elements. For example, "Y6dh!et5" is a strong password, but "House27" is a weak password. Use a strong password that you can remember so that you do not have to write it down.
Optional Parameters
For information on optional parameters, see Optional Parameters in Office Solutions.