Group & Outline in Protected Worksheets

Giganews Newsgroups
Subject: Group & Outline in Protected Worksheets
Posted by:  mkf (mkf.27so2m_1147605000.6821@excelforum-nospam.com)
Date: Sun, 14 May 2006

Can anyone help with this

I have created a file and grouped the data at 5 different levels for
viewing/reporting.  Most of the cells in the worksheet contain formulas
so I would like to project the cells but when I protect the worksheet I
lose the ability to group and ungroup the data.  Is there anyway I can
protect the cells/worksheet and still have the option of group/outline?

Many thanks

--
mkf
------------------------------------------------------------------------
mkf's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=601
View this thread:http://www.excelforum.com/showthread.php?threadid=541921

Replies