- #EXCEL 2016 PAGE BREAK PREVIEW WONT TURN OFF PDF#
- #EXCEL 2016 PAGE BREAK PREVIEW WONT TURN OFF CODE#
Squish issue by hard coding in a kludge and stretching images before printing to cover whatever the original problem was. It could be that they've tried to address the vertical The printed copy looks just like the preview. The issue expresses itself differently on my PC-it looks OK in Page Layout view but Print Preview the image overlaps the cell below it by a significant amount. Any additional insights would be greatly appreciated. The big piece is to understand what causes the cell size and therefore position to change so much among systems? I suspect this was understood by the Microsoft author and is regrettable that a list of top x things thatĪre likely to impact list was not given to at least help guide us. What is the right version for the appearance assuming they can do the math? By fixing it they will likely break some functionality. On the one hand the product needs to do the same thing it always has for backward compatibility, on the other this is a problem with how it always works and violates the WYSIWYG principle in that it Microsoft's position on this is unwinnable. Short version, same resolution, different OS, both Excel 2013 This is odd as on my multi-display system the monitors are the same resolution (albeit different models) and therefore remote system is forced to my native resolution at connection (citrix). Noteworthy the column widths are different when opened on different machines.
#EXCEL 2016 PAGE BREAK PREVIEW WONT TURN OFF CODE#
If I had more time to invest I would be curious to find with code the parent objects of the pictures and examine any positioning they have such as top and left properties. Of different sized cells as well as theme choice. Some additional, fiddling the Size and Properties, Sizing option (move and size with cells / Do not etc.) does not seem to impact as long as the image lands cleanly in the same column on both systems. I didn't want to fiddle with sizing and scaling) so that it landed in column A on second system, it was good. On the first system where a circle landed in column A, it landed half in A and half in B on second system where distorted. The picture giving me trouble was landing in different cells on different systems. Remoting into another machine and working side by side on multiple displays I had a Eureeka moment. Size and properties, Properties, Move and size with cells helped a little more but did not fix it for me (more below). Setting the Metro / Metropolitan theme helped but did not fix it.
So perhaps this is still insightful for this issue? My related issue is that images appear differently on different machines. I just realized I had a thematically related issue and wrote it from that perspective. 'Code below zooms in and out of every sheet on my page.ĪctiveWorkbook.Sheets("Step 1 Itinerary").ActivateĪctiveWorkbook.Sheets("Step 2 Park Fees").ActivateĪctiveWorkbook.Sheets("Step 3 Lodges").ActivateĪctiveWorkbook.Sheets("Step 4 Extras").ActivateĪctiveWorkbook.Sheets("Step 5 Review").ActivateĪctiveWorkbook.Sheets("Step 1 Itinerary").Activate 'returns user to first sheet IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True
MsgBox "The operation was not successful"ĪctiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Opendialog, Quality:=xlQualityStandard, _
Opendialog = Application.GetSaveAsFilename(Sheets("Step 1 Itinerary").Range("F7").Value & " Workbook - " & Format(Now, "yyyy-mm-dd hhmm"), filefilter:="PDF Files (*.pdf), *.pdf", _ The code I used is below: Sub PrintPDFEntireWorkbook() Hopefully this will help someone else facing this problem as I found no fix online.
#EXCEL 2016 PAGE BREAK PREVIEW WONT TURN OFF PDF#
So all I did is add a short macro to my print pdf macro to access each page and zoom in and out again to the desired level and this worked. So every time I saved a pdf I'd have to zoom in and zoom out and the images would return to normal. Into them (keeping the rest of the document in the same zoom level). Actually, it doesn't resize the images, it zooms When I'm using MACRO's and when I save a worksheet as PDF it works fine, but Workbooks PDF causes all images on my sheets to expand. A bit late in the game but I may have found a workaround for this problem.
0 kommentar(er)
