Problems using outlines on a protected ***

From: corrie (corrie.17ld19_at_excelforum-nospam.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 11:18:47 -0500

The spread*** that I am building is for giving price quotes for server
builds. I need to use grouping and outline to be able to shrink each
section down to just subtotals (subtotal of server components,
back-ups, and software). This is no problem, the problem is however
that the functions that are used to calculate everything need to be in
locked cells. As soon as I lock the formula cells, and protect the
***, I can't use the outline buttons on the side to shrink or expand.
I tried changing the protecting to include formatting,inserting and
deleting columns and rows, but it still won't let me use them.

I would appreciate any suggestions... thanks! 

---
Message posted from http://www.ExcelForum.com/