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