How to protect sheet but allow grouping to work

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
 
D

Dave Peterson

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
 
Top