Enable Group/Ungroup in protected sheet

Anonymous

Dear solver,

I have an excel sheet which is renamed as "Emp Summary" which is protected without password.

In this protected sheet, I want to enable the Group/Ungroup option to show/hide row no. 34 to 42.

How to do that? Will macro must be require? If yes, then please write the code for me. I would appreciate if this could be done withouth a macro,

even by other trick/option.

Also, if I send the same file to another user, will he/she also requires to enable macro at his/her end?

Please help.

Many thanks.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.7K MVP Volunteer Moderator

You need VBA for this, and the end user will need to allow macros for this to work.

Press Alt+F11 to activate the Visual Basic Editor.

Double-click ThisWorkbook, under Microsoft Excel Objects in the project explorer on the left hand side.

Copy the following code into the module that appears:

Private Sub Workbook_Open()

With Worksheets("Emp Summary")

.EnableOutlining = True

.Protect UserInterfaceOnly:=True

End With

End Sub

This code will be executed automatically each time the workbook is opened.

0 comments

91 additional answers

HansV 462.7K Reputation points MVP Volunteer Moderator

2017-05-10T15:34:44+00:00

VBA code doesn't work in Excel Online. I fear that it currently isn't possible to obtain the same effect in Excel Online.
Was this answer helpful?

0 comments No comments
Anonymous

2017-05-10T10:39:35+00:00

This solution works well to enable groups on protected worksheets in the Excel Desktop application.

Do you have a solution to enabling groups on protected worksheets in Excel Online?

The VBA solution doesn't appear to work using Excel Online.
Was this answer helpful?

0 comments No comments
HansV 462.7K Reputation points MVP Volunteer Moderator

2017-05-02T15:46:38+00:00

You can submit a request on https://excel.uservoice.com
Was this answer helpful?

0 comments No comments
Anonymous

2017-05-02T14:46:20+00:00

We need to be able to expand and collapse already created groups in a protected file WITHOUT using a macro. Many corporations and government agencies restrict the use of macros in Office files, or rather restrict macros in general, as a security measure.

Is there a way now to expand and collapse already created groups in a protected file? If not, please incorporate into future releases and updates.
Was this answer helpful?

0 comments No comments