Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically keeping cells together when printed.
Is there an option (or a simple programmatic way) to give a group of
cells an attribute that will force them to stay on the same page when printed? I have a sheet that essentially works as two print areas, side by side. The first part is a data entry area, and because of the way the entry works, I have that one all set. The second part, however, is generated by a script that reads the data entry fields, passes the values to some objects, and generates a report. The report varies in size and shape, but if possible, I would like to make it so that certain parts of it are not allowed to break across pages. The script already formats the cells, so if there was a formatting attribute I could set, that would be ideal. I can't find one, though. Does anyone have any other ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically keeping cells together when printed.
Giving this another shot.
It seems to me that, if there's not a sneaky way to store some kind of readable attribute in the cells, I'm stuck either having the script figure out which parts of the report are headings based on the formatting or...well, I can't think of anything else that will give me what I want. Adding a name to the cells would work in theory, but this sheet is going to be copied literally hundreds of times, and I don't want that many local names floating around in the workbook. Any other ideas on a range property that is easy to set and retrieve, unobtrusive, and won't interfere with the way the information looks? Jeremy wrote: Is there an option (or a simple programmatic way) to give a group of cells an attribute that will force them to stay on the same page when printed? I have a sheet that essentially works as two print areas, side by side. The first part is a data entry area, and because of the way the entry works, I have that one all set. The second part, however, is generated by a script that reads the data entry fields, passes the values to some objects, and generates a report. The report varies in size and shape, but if possible, I would like to make it so that certain parts of it are not allowed to break across pages. The script already formats the cells, so if there was a formatting attribute I could set, that would be ideal. I can't find one, though. Does anyone have any other ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show date printed, updated only when worksheet printed? | Excel Discussion (Misc queries) | |||
Automatically update a number when printed | Excel Discussion (Misc queries) | |||
Cells are empty when printed. How can I fix this? | Excel Discussion (Misc queries) | |||
Need diagonal lines behind printed cells. | Excel Discussion (Misc queries) | |||
How do I exclude empty cells from being printed? | Excel Discussion (Misc queries) |