You can do it manually, but you'd still have to do it each time you open the
workbook.

Open the workbook.
hit alt-f8 (to get to the VBE -- where those macros live!)
hit ctrl-r (to see the project explorer -- like windows explorer)
find your workbook/project and click on it
hit the asterisk on the number keypad, not shift-8
this will expand all the levels of the project.

Look for your worksheet name and click on it
hit F4 to see its properties.

Look for the Enableoutlining property and change that to True.

======
The macro doesn't look too bad, huh?


carlyman wrote:

Thanks Dave, but is it possible to do without using Macros? I try to
avoid them as much as possible unless absolutely necessary.

I grouped the rows by going to "Data - Group and Outline - Group"

Again, thanks for your help.
JC

--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=469911

--

Dave Peterson