Hi there,
I have a bit of a problem and I have no idea, yet, how to solve it. Here is my problem. I have a worksheet, which I want to use as a form. This Worksheet contains 6 blocks. Block 1 and 2 contain static data. Block 3 is optionally visible by clicking a radio button in block 2 (macro programmed). Block 4 is always visible. Block 5 is also optionally visible by clicking a radio button in block2 and block 6 is also always visible (static data). Block 3,4 and 5 will contain dynamic data. Now here's the challenge.
When printing I see 3 pages. Page 1 seems normal. Page 2 and 3 show data from page 1 added by data from page 2 and 3?? I have already tried to set page breaks (no luck). I tried dynamic printing, but this obviously only counts for pages with dynamic data.
What I want? If block 3 and 5 are selected (single or simultaniously) the data within the cells must be printed. Rows which do not contain any data must not be printed. If rows are added these must be printed also, in case of adding more data then rows.
How can I realize this? Is it also possible to distribute the data evenly on the pages to be printed? I can sent the sheet in question if that makes it more understandable.
Please excuse me for not going through all the threads, I simply haven't got the time at this moment. I would be very happy if someone could come up with an answer.
Thanks in advance,
Marco (Holland)
I have a bit of a problem and I have no idea, yet, how to solve it. Here is my problem. I have a worksheet, which I want to use as a form. This Worksheet contains 6 blocks. Block 1 and 2 contain static data. Block 3 is optionally visible by clicking a radio button in block 2 (macro programmed). Block 4 is always visible. Block 5 is also optionally visible by clicking a radio button in block2 and block 6 is also always visible (static data). Block 3,4 and 5 will contain dynamic data. Now here's the challenge.
When printing I see 3 pages. Page 1 seems normal. Page 2 and 3 show data from page 1 added by data from page 2 and 3?? I have already tried to set page breaks (no luck). I tried dynamic printing, but this obviously only counts for pages with dynamic data.
What I want? If block 3 and 5 are selected (single or simultaniously) the data within the cells must be printed. Rows which do not contain any data must not be printed. If rows are added these must be printed also, in case of adding more data then rows.
How can I realize this? Is it also possible to distribute the data evenly on the pages to be printed? I can sent the sheet in question if that makes it more understandable.
Please excuse me for not going through all the threads, I simply haven't got the time at this moment. I would be very happy if someone could come up with an answer.
Thanks in advance,
Marco (Holland)
