Prev: If a date range contains a leap year (date)
Next: Calculate a ratio of two numbers to the total
From: KGardner on 3 Jul 2008 11:16
We are currently using the Outline function. Our problem is individuals will
expand the outline, enter information, and then collapse it. We then convert
the worksheet to a tiff (durable format). The problem is if the outline is
collapsed it does not print.

What we would like to happen if values exist in certain cells not to allow
them to collapse.

Thanks in advance
From: Tieske on 3 Jul 2008 14:56
using VBA you can collaps/expand on a per outline-level basis (not per
individual branch).

alternative; expand everything?, or if that is not sufficient, use a VBA
macro to expand all and then hide all empty rows before printing


"KGardner" <KGardner(a)discussions.microsoft.com> wrote in message
news:EA33742E-7208-4720-B264-023278CE886D(a)microsoft.com...
> We are currently using the Outline function. Our problem is individuals
> will
> expand the outline, enter information, and then collapse it. We then
> convert
> the worksheet to a tiff (durable format). The problem is if the outline
> is
> collapsed it does not print.
>
> What we would like to happen if values exist in certain cells not to allow
> them to collapse.
>
> Thanks in advance

 | 
Pages: 1
Prev: If a date range contains a leap year (date)
Next: Calculate a ratio of two numbers to the total