Cell height changes on shared documents

I am having a problem getting a quote form to print correctly. It prints as expected when I print it because I created it, but when my boss prints it the cell heights grow. They show to be the same height as on my computer, but they do not print the same. This makes the overall height of the sheet about 1/2" too tall and it throws the margins off. This is in the design stage and only my boss and I have tried it. He has the same model of printer, same version of Excel, and I double checked to make sure that the margins & page layout was the same. Everything that I can think of to check is the same.
This has to print exactly the same no matter who opens it and prints a quote. Any ideas?

Correction to the above.
I thought the actual cell height in pixels remained the same, they do not. For instance, a row that is 71 pixels high on my computer is over 80 pixels high on his. This is a protected worksheet. Why would the row height change?

Welcome to the forum.

The only thing I can think of is that one of the default settings somewhere on your two computers is different - maybe the 'Normal' style, or something like that - though if the row heights have been manually set, they should over-write anything like that...
I assume you've tried setting the sheet to print x pages wide by y pages high, with manual page breaks set? If not, try doing so - that won't fix any on-screen-display issues, but at least should make it print the same.

I think I may have found a VBA solution to the row height problem, here: http://excelribbon.tips.net/T008774_...t_Changes.html
Put this code in the workbook code (not a module)* - it will run every time the file is opened:

Please Login or Register  to view this content.

Alternatively, if you want it to run only on one worksheet, when that sheet is opened (activated), use this version (amended from the above by me) - this code also shows how to set different widths/heights for different ranges:

Please Login or Register  to view this content.

* To put the first code in the workbook code, open the VBA editor, right-click on 'this workbook' (top-left) and click 'view code'.
** To put the second in only one worksheet, right-click that worksheet and 'view code'.

I hope that's of some help.

In answer to your second question, I'm not sure how to set the normal Print/Print Preview buttons, sorry.

ps When posting code, please put it in CODE tags, by selecting it and clicking the # icon. Thanks.