+ Reply to Thread
Results 1 to 4 of 4

Cell height changes on shared documents

  1. #1
    Registered User
    Join Date
    12-03-2015
    Location
    Texas
    MS-Off Ver
    Office 2013
    Posts
    2

    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?
    Last edited by dstnwst; 11-09-2016 at 07:19 PM. Reason: found other information

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: Cell height changes on shared documents

    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.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    12-03-2015
    Location
    Texas
    MS-Off Ver
    Office 2013
    Posts
    2

    Re: Cell height changes on shared documents

    Thanks for the welcome, and the reply. I have been a member on here for a while, but this is my first posted question.
    Some of the cell heights were left at 17 pixels, which I assume is the "default" height. Some of the cells heights were changed to 71 pixels to allow room for product descriptions of different lengths. All of them changed when printed from another computer.
    The print area is set for either one sheet or two sheets by a macro, and is based on the number of entries on the quote. I found it on the internet, but there may be a cleaner way to do it. I will attach it below.
    I used 10 point Times New Roman font for the majority of the quote form, and 8 point for the "fine print" area. This remained unchanged regardless of which user printed it.

    Here is the macro I used to set the print area. I had to include a Print Quote button to perform this action because the standard print button printed both pages whether there was anything on page two or not. I would like to change this, if possible, to use the normal print and print preview buttons.

    Sub ChangePrintArea()
    ' if cell ORDER ENTRY!A18 has a value in it then
    If Range("'ORDER ENTRY'!A18").Value > 0 Then
    ' make the print area from cell A1 to cell g70
    ActiveSheet.PageSetup.PrintArea = "$A$1:$g$70"
    ' but if cell ORDER ENTRY!A18 has no value in it then
    ElseIf Range("'ORDER ENTRY'!A18").Value = "" Then
    ' make the print area from cell A1 to g35
    ActiveSheet.PageSetup.PrintArea = "$A$1:$g$35"
    End If
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
    End Sub

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,402

    Re: Cell height changes on shared documents

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-14-2013, 02:00 PM
  2. Autosize only height of comment box relative to height of cell comment
    By Shanthan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 10:25 AM
  3. Shared Documents - General
    By Lanz Cabrera in forum Excel General
    Replies: 0
    Last Post: 09-28-2012, 02:23 PM
  4. Excel 2007 : compare and merge NON-shared documents
    By davbeisner in forum Excel General
    Replies: 0
    Last Post: 06-29-2010, 08:43 AM
  5. Replies: 0
    Last Post: 06-21-2006, 03:45 AM
  6. Phantom documents saved from shared workbook
    By natalie st ange in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2006, 12:15 PM
  7. [SOLVED] need to dbl row height without changing height of cell next to it
    By Excel-Illiterate in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-15-2006, 08:15 PM
  8. Replies: 0
    Last Post: 10-26-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1