Print but don't show user the "cancel" option

[ILoveStMartin]

My code (I use named cells and named areas)
#ActiveSheet.PageSetup.PrintArea = "PrintReleaseForSub"
ActiveWindow.SelectedSheets.PrintOut Copies:=1"

What change can I make to print - with no options available to user.

[saravnepali]

If you want to print physical paper, and you know the printer name
1

You can add the ActivePrinter as an argument to PrintOut.

Please Login or Register  to view this content.

Display print setup

Please Login or Register  to view this content.

Unless you want to print, as pdf file

Please Login or Register  to view this content.

[ILoveStMartin]

Thank you!! I may go with your PDF suggestion.
Worksheet has money posted to it weekly until until funds reach 0
The macros takes their entries, arranged differently, prints and then updates the worksheet for the next weeks postings.
While I have been unable to move fast enough to see what would happen if I clicked the cancel button, i am concerned that if they did cancel, the macro would stop.
You have any knowledge of what could happen if printing is canceled when printing is in the middle of a "doing things to the worksheet" macro?
What a Dummy I am at this - but just had an idea - is there code I could use that would made sure nothing stops if they hit the cancel???

[saravnepali]

It is very hard to understand what exactly you need.

It would be easier to have a sample workbook for this.

Refer to the yellow ribbon at the top.

Also, as a general forum rule, it is advisable to close old thread AND have NEW thread open for a new topic