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

You have a reply in .misc.

dwsmha wrote:

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

--

Dave Peterson