Esthetical problem when printing

[webster188]

Hi,

I am stuck on a simple but for me unsolvable problem. Hope somebody can help me.

I have a worksheet with my user interface and several hidden sheets where calculations are performed.
There is also a hidden sheet where the result of the calculations are grouped in a nice layout for printing.

But whenever I issue a print command (printing is started from a custom menu - print command is given via VBA), I get on my user interface page the typical lines with which Excel indicates the page size (or print area).
I have no clue how to avoid this to happen.

Regards,

Dimitri

 

[p45cal]

You'll need to add a line akin to:
ActiveSheet.DisplayPageBreaks = False
to the macro, perhaps adjust the sheet's name in this line:
Sheets("your user interface sheet name here").DisplayPageBreaks = False
towards the end of the macro.
If you post the macro's code…

 

[webster188]

Thanks for the quick answer.
I knew that there would be a property for this but couldn't find it.

Works like a charm. Thanks again

Regards,

Dimitri