Others can't use groupings in my protected sheet

[Rookie14]

Hi - I am using Office 2013 and have a protected sheet where I would like users to still be able to open/close groupings.

I have used the code:
Private Sub Worksheet_Open()
With Worksheet ("Europe")
.Unprotect Password:="PW12"
.Protect Password:="PW12", Userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

This works for me, but not for my colleagues. I am new to VBA and not sure why it doesn't work. I have about 11 other identical tabs I need to make this work on.

Thanks in advance.

 

[RoryA]

The routine should be called Workbook_Open and not Worksheet_Open and it must be in the ThisWorkbook module. Your colleagues must also of course have macros enabled.

 

[Rookie14]

The routine should be called Workbook_Open and not Worksheet_Open and it must be in the ThisWorkbook module. Your colleagues must also of course have macros enabled.

Just tried this - it works now thanks!