Hi,

I have a long sheet and need to have control over the pagebreaks. I will
hide some areas sometimes and need to be sure sheets doesn't come empty etc.
I has failures sometimes over this.

I wonder also if there might be more probelms if there is other printers
connected and if yes - what to do about it.

Any code snippets to share, I would be grateful?

/Regards

Have you tried setting the page breaks to automatic?

--

Vasant

"Marie J-son" wrote in message
...
Hi,

I have a long sheet and need to have control over the pagebreaks. I will
hide some areas sometimes and need to be sure sheets doesn't come empty
etc.
I has failures sometimes over this.

I wonder also if there might be more probelms if there is other printers
connected and if yes - what to do about it.

Any code snippets to share, I would be grateful?

/Regards

Sorry, I should have mention that if I do that, the breaks are not where I
want them to be. It is not possible to do that.

/Regards



"Vasant Nanavati" <vasantn *AT* aol *DOT* com skrev i meddelandet
...
Have you tried setting the page breaks to automatic?

--

Vasant

"Marie J-son" wrote in message
...
Hi,

I have a long sheet and need to have control over the pagebreaks. I will
hide some areas sometimes and need to be sure sheets doesn't come empty
etc.
I has failures sometimes over this.

I wonder also if there might be more probelms if there is other printers
connected and if yes - what to do about it.

Any code snippets to share, I would be grateful?

/Regards

I don't think you can do what you want, then. You would have to look at the
worksheet after you hide whatever ranges you want to hide, and then reset
the page breaks manually.

--

Vasant


"Marie J-son" wrote in message
...
Sorry, I should have mention that if I do that, the breaks are not where I
want them to be. It is not possible to do that.

/Regards



"Vasant Nanavati" <vasantn *AT* aol *DOT* com skrev i meddelandet
...
Have you tried setting the page breaks to automatic?

--

Vasant

"Marie J-son" wrote in message
...
Hi,

I have a long sheet and need to have control over the pagebreaks. I
will
hide some areas sometimes and need to be sure sheets doesn't come empty
etc.
I has failures sometimes over this.

I wonder also if there might be more probelms if there is other
printers
connected and if yes - what to do about it.

Any code snippets to share, I would be grateful?

/Regards

Hi all,
It must be able to do. I thinking of a loop to set each pagebrake by code
and stop when the pagebrake location is identified to be in the end. I only
need to assure that the pagebrakes aren't to far away so automatic brakes
occure.

Doesn't anybodey have done this before?

/Regards



"Marie J-son" skrev i meddelandet
...
Hi,

I have a long sheet and need to have control over the pagebreaks. I will
hide some areas sometimes and need to be sure sheets doesn't come empty
etc. I has failures sometimes over this.

I wonder also if there might be more probelms if there is other printers
connected and if yes - what to do about it.

Any code snippets to share, I would be grateful?

/Regards