How to protect sheet but allow grouping to work

  • Thread starter Thread starter dwsmha
  • Start date Start date
D

dwsmha

Hello, I have a spreadsheet with multiple sheets, and want to prevent
people from seeing my formulas by protected the sheets. However, I
have data "grouped." If I protect the sheet, people can't click on the
"+" to expand groupings. How do I accomplish both?
David
 
You have a reply in .misc.
Hello, I have a spreadsheet with multiple sheets, and want to prevent
people from seeing my formulas by protected the sheets. However, I
have data "grouped." If I protect the sheet, people can't click on the
"+" to expand groupings. How do I accomplish both?
David
Click to expand...
 
You must log in or register to reply here.

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
How do I protect sheet, but allow "group" function to work 1
Protected cells can't be grouped 1
Protected Sheet and grouping 1
unable to protect cells in macro sheet b/c runtime error 1004 1
Protecting Sheets with drop down boxes 1
Grouping on protected worksheets 4
hide columns on a protected sheet 2

Back
Top