View Single Post
  #1   Report Post  
dwsmha
 
Posts: n/a
Default How to protect sheet but allow grouping to work


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


--
dwsmha
------------------------------------------------------------------------
dwsmha's Profile: http://www.excelforum.com/member.php...o&userid=26764
View this thread: http://www.excelforum.com/showthread...hreadid=400173