Thread: VBA 2007 - allow formatting of cells in protected sheet

Hello,

I am using Excel 2007 and have a problem regarding my VBA code. We protected various cells in all sheets (different cells for each sheet) with a password.
Now I want the people, which do not have the password to be allowed to do the following things:
- add comments and format unprotected cells
- hide and unhide colums and rows of protected and unprotected cells
- be able to see the contents of protected cells but not be able to delete or manipulate them

I would be grateful for any kind of help!

Thanks a lot in advance!


Here comes my code:

Private Sub Workbook_Open()

Dim wSh As Worksheet

For Each wSh In ThisWorkbook.Worksheets

With wSh
.Protect Password:="xxx", UserInterfaceOnly:=True
.EnableOutlining = True
End With

Next wSh
ThisWorkbook.Worksheets("xyz").Unprotect Password:="xxx"

End Sub