sthompson07
New Member
- Joined
- May 8, 2018
- Messages
- 1
I have three sheets that are protected and all have grouped areas. I need my users to be able to use these features while the sheet is protected. I found this VBA code online and turned the workbook from .xlsx to .xlsm. Works perfect for sheet 1, how to i add in the ability for sheet 2 and 3.
I should I add I do not right VBA and have no experience, but I can google. just can't find this answer.
Private Sub Workbook_Open()
With Worksheets("Sheet 1")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With
End Sub
Thank you
I should I add I do not right VBA and have no experience, but I can google. just can't find this answer.
Private Sub Workbook_Open()
With Worksheets("Sheet 1")
.EnableOutlining = True
.Protect UserInterfaceOnly:=True
End With
End Sub
Thank you