Hello -
I have a workbook that I am password protecting so that users can only edit certain cells. I have areas that are grouped, however, and I when I protect the workbook, you cannot group/ungroup these columns. I found this thread and tried to incorporate it into my workbook:
http://www.mrexcel.com/forum/showthread.php?t=206683
I pasted this code into the "This Workbook" section of VBA:
Private Sub Workbook_Open()
Dim wksht As Worksheet
For Each wksht In ThisWorkbook.Sheets
With wksht
.Unprotect "tnskmg"
.EnableOutlining = True
.Protect "tnskmg", contents:=True, userInterfaceOnly:=True
End With
Next wksht
End Sub
Even after this, I still cannot group/ungroup columns when the book is protected.
Can someone help please? I would be more than happy to email an example of the file if that helps.
Thanks!
Kris
I have a workbook that I am password protecting so that users can only edit certain cells. I have areas that are grouped, however, and I when I protect the workbook, you cannot group/ungroup these columns. I found this thread and tried to incorporate it into my workbook:
http://www.mrexcel.com/forum/showthread.php?t=206683
I pasted this code into the "This Workbook" section of VBA:
Private Sub Workbook_Open()
Dim wksht As Worksheet
For Each wksht In ThisWorkbook.Sheets
With wksht
.Unprotect "tnskmg"
.EnableOutlining = True
.Protect "tnskmg", contents:=True, userInterfaceOnly:=True
End With
Next wksht
End Sub
Even after this, I still cannot group/ungroup columns when the book is protected.
Can someone help please? I would be more than happy to email an example of the file if that helps.
Thanks!
Kris