Hi: I have several worksheets that have locked cells and unlocked cells. User
are able to select unlocked cells to enter data. I have a VBA code I got off
of another post, but it only allows users to select unlocked cells on each
worksheet. How can I also allow users to format unlocked cells using VBA so I
don't have to go one by one protecting each sheet in the workbook. Mainly I
would like for them to be able to change the font color. This is what I
currently have:
Sub LockDown()
For Each ws In Worksheets
ws.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, _
Password:="elara"
Next ws
End Sub

Sub UnlockAll()
For Each ws In Worksheets
ws.Unprotect Password:="elara"
Next ws
End Sub


Thank You!