Hi Folks,

I have a simple macro that protects all sheets in a workbook, yet allows
users to select and format any cell locked or not... I'm looking to add to
this to allow users to insert comments but I do not see how that is an option
when protection is taking place through the macro. As understand it you can
select an Edit Objects check box if you are protecting sheets via the tools
-- protect sheets option.

below is my simple macro.

Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="###", AllowFormattingCells:=True
Next ws