Protect Method

This method protects a workbook so that it cannot be modified. Its syntax is:

WorkbookObject.Protect(Password, Structure, Windows)

The method also applies to charts and worksheets, with a different syntax.

The optional Password parameter specifies a password (as a case-sensitive string). If this argument is omitted, the workbook will not require a password to unprotect it.

Set the optional Structure parameter to True to protect the structure of the workbook—that is, the relative position of the sheets in the workbook. The default value is False.

Set the optional Windows parameter to True to protect the workbook windows. The default is

False.

0 0

Post a comment