Grouping Function not working on a protected sheet

Question

Grouping Function not working on a protected sheet

Anonymous

I have a sheet with about 3 level of Grouping, but when I protect the sheet, I can no longer use the grouping (1, 2, 3) buttons to expand and contract the data.

Any ideas?

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

5 answers

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

Hi Hans,

I just discovered another problem with the file I am hoping you can help with. On some of the tabs, I have " DropDown Form Controls" that are linked to macros. The macros hide and unhide columns and also move columns to the left or the right using "ActiveWindow.ScrollColumn". But with the sheet protection, the macros are no longer working and I get the protection error every time I try to use the DropDown.

Please HELP!!!

Ayo

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 4

Anonymous

Thanks again Hans.

0 comments

Answer 5

Anonymous

Hi Hans,

Hope you are doing well. Can you check this tread out for me please, I will be very grateful:

Private Sub Worksheet_Change(ByVal Target As Range) not triggering

0 comments