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. 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.

Click Layout, and then select Flip horizontally.A bit late in the game but I may have found a workaround for this problem.

Mirror printing: Reverse an image or document for printing iron-on transfers. If prompted during printing, follow any instructions to manually load and flip the paper.Īdd or remove a border: Click Layout, and then click the Border menu to select a border width or select None for borderless prints. Select a binding type from the settings options or from the Layout menu. Two-sided printing (duplexing): Turn on the Double-sided or Two-Sided setting.

Print quality: From the Quality or Print Quality menu or slider, select Best, Normal, or Draft. The setting might also be available in the File > Page Setup > Paper Size menu. Paper size: Select the paper from the Paper Size menu on the main dialog if present, or click Paper Handling, select Scale to fit paper size, and then select the paper in the Destination Paper Size menu.Ĭustom paper size: Click Manage Custom Sizes in the Paper Size menu, if available. Paper type (photo, plain, specialty): Select the paper type in Media & Quality to ensure the printer properly applies the ink to the paper you loaded in the printer. The Presets menu also includes color and black and white options.

Color or black and white: Enable or turn off Print in Color or Black & White.

Scaling print in excel for mac