Using Group/Ungroup in protected worksheets

You would have to use a Workbook_Open macro to set the protection a special way when you open the workbook.

The following needs to go in the ThisWorkbook module. The password is password - you can change the text between the quotation marks to what you need it to be. The sheet with the subtotaling is called sales - you can change that below.