Problem printing worksheet

[aldi]

i have an excel app to calculate job costs, users are able to print and email the cost results automatically after they save the information, the problem i have is that the page break changes in some computers and this annoy the users because the information jumps to the next page.
i tried adjusting the page margins programmatically but it doesn't make any effect on the output.
any idea how can i fix this problem???????
please help me.
thanks in advance

 

[JESTAR]

You could send them to Print Preview instead of instant printing....

Dim MyData as Object
Set MyData = Sheets("Sheet1&quot.Cells
MyData.PrintOut Preview:=True

 

[xlbo]

Of use the hpagebreak property to set where the pagebreaks occur... Rgds
~Geoff~

 

[aldi]

thanks JESTAR i'll go your way if what xlbo is suggesting doesn't work.
thanks to both of you