| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically expanding outline section if values are present
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically expanding outline section if values are present
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding a Range Automatically | Excel Discussion (Misc queries) | |||
| How do i copy section headings automatically in excel | Excel Worksheet Functions | |||
| how do I automatically jump to the present date in a roster? | Excel Worksheet Functions | |||
| How do I make a section sort automatically? | Excel Discussion (Misc queries) | |||
| Automatically outline all email addresses in a given text by putting them in red-bold | Excel Discussion (Misc queries) | |||
Linear Mode
