This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
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
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
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
Thanks again Hans.
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