Allowing expanding and colapsing of groups in a protected workshee

  • Thread starter Thread starter Carsten
  • Start date Start date
C

Carsten

I need to allow users to expand and collapse groups in a worksheet, that is
protected - ie. I do not want people to be able to change any data.

Is this possible?
 
Not seeing an option to do that. However, if you so desire, you can make the
file itself password protected so users would have a read-only version.

for that go to Tool - Options - Security and add a Password to modify.
 

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

Collapsing all groups 0
Expanding Grouped Rows when sheet is Protected 2
Grouping on protected worksheets 4
Expanding and Collapsing Groups within a Protected Workbook 1
Expand/Collapse in Pivot Tables 2
Protected Sheet and grouping 1
expanding or collapsing groupings in protected worksheets 5
Word The More add-in for Microsoft Word 0

Back
Top