Microsoft Office Tutorials and References
In Depth Information
Table 7-7. Parameters of the Worksheet.Protect Method (continued)
Parameter
Default Description
Contents
True
When set to True , protecting the contents of a
worksheet protects any locked cells from
changes.
Scenarios
True
When set to True , the user cannot make changes
to scenarios.
UserInterfaceOnly
False
When set to True , the user interface is protected,
but the user can edit macros. When left blank or
set to False , both the user interface and macros
are protected.
AllowFormattingCells
False
When set to True , users can format any cell on a
protected worksheet.
AllowFormattingColumns
False
When set to True , users can format any column
on a protected worksheet.
AllowFormattingRows
False
When set to True , users can format any row on a
protected worksheet.
AllowInsertingColumns
False
When set to True , users can insert columns into
the protected worksheet.
AllowInsertingRows
False
When set to True , users can insert rows into the
protected worksheet.
AllowInsertingHyperlinks
False
When set to True , users can add hyperlinks to a
protected worksheet.
AllowDeletingColumns
False
When set to True , users can delete columns on
the protected worksheet, provided every cell in
the column to be deleted is unlocked.
AllowDeletingRows
False
When set to True , users can delete rows on the
protected worksheet, provided every cell in the
row to be deleted is unlocked.
AllowSorting
False
When set to True , users can sort the data on the
protected worksheet, provided every cell in the
sort range is unlocked or unprotected.
AllowFiltering
False
When set to True , users can set filters on the
protected worksheet and change filter criteria but
can’t enable or disable an auto filter.
AllowUsingPivotTables
False
When set to True , users can use PivotTables on
the protected worksheet.
Search JabSto ::




Custom Search