Worksheet protection

D

Deirdre Zube

Greetings, oh wise ones.

I've got a protected worksheet (several, actually) in which data entry cells are the only ones unlocked.

Since the document itself is quite lengthy, I want to group sections of rows. However, expanding & collapsing functions aren't then available when the sheet is protected.


Is there any way to retain the protection but enable expanding & collapsing the rows?

Thanks in advance :)

Deirdre
 

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

Grouping on protected worksheets 4
Protect worksheet but expand and collapse outline? 1
Can't insert row in data table in protected worksheet 0
Copy data using macro (with worksheet protect) 5
Insert/ delete row in protected worksheet 6
Allowing for Grouping and Ungrouping while Sheet is Protected 2
Grouping data and protecting worksheets 5
Using Groups on Protected Sheets 12

Top