Pause a Macro
Posted by Bob T on August 16, 2001 5:35 AM
Could you help this novice? I would like my print macro to either pause on the print options screen so I can tell it how many copies to print or better yet print the number of copies based on the number is a cell. Is this possible?
Also-- After my macro chooses a printer off the network, can I have it revert back to the users default printer? (not all users have the same default printer). Thanks for any help!
Posted by Joe Was on August 16, 2001 10:32 AM
If you set the print area and then setup the format on page setup and save the sheet, Excel will use these settings with the code below!
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
This is all the code you need to print the active sheet to the default settings and printer. If you set the "Copies:=1" to a cell address you can control the number of copies from a cell on the active sheet. JSW
