vba print

  1. D

    Export only one sheet as PDF - Save as prompt

    Hi Thanks for the help in advance on this matter. I wanted to have a button on a landing page of a workbook to print a specific sheet named "leather letter" on the excel file. So basically I would like that when someone clicks that button a prompt shows up with the "Save as" dialog so the...
  2. T

    Print If ComboBox5.Value=Range("K8")

    Im having issues with this code This is what i would like the code to do - ComboBox5.Value = Range ("K8") if true print if false MsgBox "Incorrect Revision" If ActiveSheet.Name = "VAM PINS" = True Then If ComboBox5.Value = Range("'VAM PINS'!$K$8") = True Then End If ActiveSheet.PrintOut...
  3. P

    VBA Print Settings for all worksheets

    What code can be used to set the paper size, orientation, print area based on current region in each worksheet? I tried to use the following but it fails: Dim wSht As Worksheet For Each wSht In Worksheets wSht.Range("A1").CurrentRegion.Select 'printsettings code Next wSht
  4. M

    VBA Print - Help Modify it since it delete active cell before running it

    Code below do great job printing my target area, but it also delete, clear active cell after I running this macro. any idea why, help me modifying it. thx Sub Print_Myproblem() Application.EnableEvents = False Dim myRange As Range Set myRange = Selection Dim S As Shape On...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top