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 created a worksheet in which I've group certain rows. When I protect the sheet, the group function is no longer useable, I get the following error message: "You cannot use this command on a protected sheet. To use this command, you must first unprotect the worksheet (Review tab, changes groups, unprotect sheet button) You may be prompted for a password".
Is there a way that I can lock/protect specific cells yet still use the group function?
Thank you,
Michele
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.
Hello - This VBA is not working for me to solve the same issue.
Any tips?
Thank you,
-Matt
Hi Dave,
I have the same problem as Maid4boys above, but I have grouped columns instead of rows.
But I am a new bee to VBA and I can't get it to work.
I have entered the code, which i found in several threads, but it doesn't work.
I have already grouped the columns, do I have to use subtotal? if yes, how?
When I click on Developer and then Macro, do I have to enter any details there?
Macro security I have it on "disable all macros except digitally signed macros"
I have protected the sheet and the workbook as week.
I would be very grateful if you could help.
Many thanks,
Antonella
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
What about for multiple worksheets? I tried adding another module but excel won'y allow 2 Auto_Open modules?. I tried added 2 work sheet name ("Tab1", "Tab2) but got a Compile Error saying "Wrong number of arguments or invalid property assignment".