Protect macro and comments

[Stephen]

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

 

[Jim Cone]

DrawingObjects:=False,
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Stephen" <[email protected]>
wrote in message
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

 

[Stephen]

That's the one!

Thanks a bunch for the post, very helpful.