| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
UserForm Print Extra Copies
Hi
On a user form I have a command button "Print1" which on clicking uses the following macro to print the sheet Sub Macro4() Sheets("Print1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub What would I need to add so that on clicking the command button it would ask how many copies required. Any help much appreciated Cheers Mully |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Copy limit | Excel Discussion (Misc queries) | |||
| HOW DO I PRINT MULTIPLE COPIES IN EXCEL | Excel Discussion (Misc queries) | |||
| print multiple copies of the same page with sequential numbers | Excel Discussion (Misc queries) | |||
| Can one have an extra margin gutter, for binding a document print. | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Threaded Mode
