Macro to compress grouped rows

From: Kelly (anonymous_at_discussions.microsoft.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 07:02:07 -0700

I have a spread*** that looks like the following

   FY03
   Total
 + Product A total
 + Product A one type
 + Product A another type
 + Product B Total
 + Product B one type
 + Product B another type
   Line for another type of total
   Block of text items

   FY04
   Total
 + Product A total
 + Product A one type
 + Product A another type
 + Product B Total
 + Product B one type
 + Product B another type
   Line for another type of total
   Block of text items
Etc for FY05, FY06 etc etc

I have a powerpoint slide in one file that needs all the
info that has the +'s beside it hidden, and one that
wants them to show. Right now (to print out one file) I
go through and compress all the FY's individually. Then
for the next file I go through and Uncompress each FY
individually.

Is there a way to write a macro to have all compress then
have one to have all uncompressed??

Kelly