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.
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.
If you want to print physical paper, and you know the printer name
1
You can add the ActivePrinter as an argument to PrintOut.
Display print setupPlease Login or Register to view this content.
Unless you want to print, as pdf filePlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by saravnepali; 12-19-2019 at 01:17 AM.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
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???
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks