Unable to use Grouping with Protection

D

dan2004

I am struggling with spreadsheet in Excel '97. I have Jan - Dec in
collapsible groups and am trying to password protect the sheet so that
data can only be input into the relevant cells. When I activate the
protection the grouping function stops working making it impossible to
expand the months to input the data!

Please, please, please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protected Sheet - Using Groups without a Macro 1
Grouping on protected worksheets 4
Expanding Grouped Rows when sheet is Protected 2
Allowing expanding and colapsing of groups in a protected workshee 1
Expand and Collaps Groups while Protected 0
Expanding and Collapsing Groups within a Protected Workbook 1
Protected cells can't be grouped 1
Can I use the subtotal function while a worksheet is protected? 0

Top