Protected Sheet (Group/Ungroup)

I have a protected sheet/Tab in excel that has information thats grouped by section by rows on the left. I need to keep this sheet/tab protected but I need to be able to allow the people who are viewing the sheet to group/ungroup the tab.

How can I do this?

Good morning Excel Fans.

Any suggestions?

Hi,

It needs to go in the Thisworkbook module - it doesn't tell you that in the article but it works just fine.

Ed

I am using Excel 2003 but those instructions are for excel 2000.

Is this an issue or am I doing something wrong?

It works for me in Excel 2003

Ed