i found this code, and it works well so long as i haven't closed my workbook. yes i saved my data before closing. but when i open the workbook it won't let me use the group and ungroup "+".
i tried this from a previous thread, was told to not reply in their thread, so here is my dilemma:
"Drop this in "ThisWorkbook" under your Microsoft Excel Objects in VBA:
Private Sub Workbook_Open()
Dim wksht As Worksheet
For Each wksht In ThisWorkbook.Sheets
With wksht
.Unprotect "password"
.EnableOutlining = True
.Protect "password", contents:=True, userInterfaceOnly:=True
End With
Next wksht
End Sub
"
*This code works, but once i open it again, i can't group/ungroup. can someone please help me out with this asap!!!*
Bookmarks