Hi yudlugar,

Hoping you can help me too. I tried the code you mentioned in this post. But still encountering some issues

I entered the code, saved the file, exited and reopened and tried the group / ungroup in one of the sheet, but it still come up with the original error
However I can get the group and ungroup to work if I go into "Run Macro" and run the each of the macros.

How can get the Macro all ready to go soon as the file is open?.

Tom

Quote Originally Posted by yudlugar View Post
I'm not sure where the option is in the userinterface but by macro:
Sub Macro_1()
With Worksheets("Review")
.Protect Password:="protect", Userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub
Will allow the user to use the group functionality.