I'm having dificulty getting the following Sub to run within my Excel 2010 *.xlsm file. I have the following pasted at top of my VB editor window. My worksheet, "STA High Power ASSY" is already setup with Excel grouping feature. However, when I protect the worksheet, the grouping and ungrouping does not work. I entered the following in my VB editor. Macros are enabled. It may not be an issue with Sub, but may be my workbook, not sure.
Private Sub Workbook_Open()
With Sheets("STA High Power ASSY")
.Unprotect Password:="Secret - Password entered here"
.Protect Password:="Secret - Password", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub
Thank you,
Lynn
Bookmarks