LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show date printed, updated only when worksheet printed? Sam Excel Discussion (Misc queries) 4 April 4th 23 10:49 AM
Automatically update a number when printed excelhelp Excel Discussion (Misc queries) 1 April 30th 10 10:58 AM
Cells are empty when printed. How can I fix this? Mongoose Excel Discussion (Misc queries) 1 March 10th 09 01:05 PM
Need diagonal lines behind printed cells. Jimmy D[_2_] Excel Discussion (Misc queries) 2 June 26th 08 04:34 AM
How do I exclude empty cells from being printed? pox Excel Discussion (Misc queries) 1 August 13th 05 11:50 AM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"