Protecting sheets

Hi there, first post and first question!!

Is it possible to protect a sheet and still use the expansion buttons for the grouping of data? I have tried to get around this but whenever the sheet is protected I cannot use the expansion. The idea is for employees to be able to enter mass data and then hide the cells for the figures to be summarised using a 'sum' function at the end of the row. i.e managers want the final figures but not all the data on a monthly basis.

Also - I am having the same issues with a macro on the front sheet, when the sheet is protected the macro comes up with an error message as it copies previous months figures and pastes them across to give a 'movement in the month' column for financial reporting. I am sure it is possible to protect the data and have the macro still run.

Any help appreciated!

So just copy the code listed and paste into the code tablet for each sheet i want to use (obviously changing the password) and then all the expansion buttons should work automatically?

Ah, I see !!

One final question then - I have got multiple sheets that I want to use this function for within the workbook.

How should the code look in this instance, i.e......

Private Sub Workbook_Open()
With Sheet3, sheet7, sheet9
.Protect Password:="Secret", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub

As it only works at present with the initial sheet (sheet3)