VBA Code: When setting password, what does the true true true mean?

[Badnames]

In this line of code what do the different trues represent? I've been rewriting this portion of code for a lil bit now, and figure its time I learn what I'm doing.

Sub Protect()
Dim Password As String
Password = "protectresults"
Worksheets("Sheet1").Protect Password, True, True, True
End Sub

 

[Andrew Poulsom]

The first 4 arguments of the Protect method are Password, DrawingObjects, Contents and Scenarios.

 

[Badnames]

Thanks Andrew!

Another question, I'm trying to setup the sheets so when protected users can:

Select Locked cells
Select Unlocked Cells
Format Cells
Format Columns
Format Rows


Do I just simply protect the sheet manually myself once before I run the macro to protect it?

 

[Andrew Poulsom]

The full syntax for the Protect method is:

Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)

The first 2 items in your list are contolled by the Worksheets's EnableSelection property. The possible settings are:

xlNoSelection prevents any selection on the sheet
xlUnlockedCells allows only those cells whose Locked property is False to be selected
xlNoRestrictions allows any cell to be selected.