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!