You cannot use this command on a protected sheet.

Anonymous
2010-11-03T16:57:04+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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

7 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2017-01-13T16:05:01+00:00

    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

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-06-08T15:01:11+00:00

    Hello - This VBA is not working for me to solve the same issue.

    Any tips?

    Thank you,

    -Matt

    Was this answer helpful?

    0 comments