Grouping and Ungrouping is not working on Protected report

[Former Member]

Hi People,

Ungrouping and Grouping feature is not working on my protected EPM report.

I have protect the sheet as I have some hidden rows and colums so i don't want to show them to user.

Can you please suggest me how to use Grouping and Ungrouping feature on protected sheet?

Thanks,

Vishu

[former_member186338 · Accepted solution]

Not possible to solve this issue without VBA... Please search google...

Vadim

[Former Member · Accepted solution]

Thanks Vadin.

can you give me some sample VBA code to solve this?

Regards,

Vishu

[Former Member · Accepted solution]

I have used below code but it did not work.

Sub TestMacro()

ActiveSheet.Unprotect Password:="<Vishu>"

' Your Macro Code Here

ActiveSheet.Protect Password:="<Vishu>"

End Sub

Vishu is my epm protect sheet password.

[Former Member · Accepted solution]

Hi Vishu,

Try this code below,

    With Worksheets("Sheet Name")

       .Protect Password:="Secret", UserInterfaceOnly:=True

      .EnableOutlining = True

    End With

Thanks.