Protect macro and comments

G

Guest

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top