Hello,
My question is: I have protected worksheets that I want to allow any end user to format the column width and the row height. I also want to allow any end user to group and ungroup existing grouped columns/rows. I have a VBA for the grouping issue -
Private Sub Workbook_Open()
With Worksheets("General")
.Protect Password:="Password", Userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
However, when I initially set the protection and check off "Format Columns" and "Format Rows" the VBA essentially overrides those settings. I am trying to figure out how to allow both the grouping/ungrouping as well as the column/row formatting at the same time. I have tried to run separate Macros for both, but they seemed to create further issues. Any suggestions would be extremely helpful!
My question is: I have protected worksheets that I want to allow any end user to format the column width and the row height. I also want to allow any end user to group and ungroup existing grouped columns/rows. I have a VBA for the grouping issue -
Private Sub Workbook_Open()
With Worksheets("General")
.Protect Password:="Password", Userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
However, when I initially set the protection and check off "Format Columns" and "Format Rows" the VBA essentially overrides those settings. I am trying to figure out how to allow both the grouping/ungrouping as well as the column/row formatting at the same time. I have tried to run separate Macros for both, but they seemed to create further issues. Any suggestions would be extremely helpful!