| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Marco print issue!!!
i have created a marco to be able to print the sheet to a specified printer and i have attached the macro to a button, but when i print it creates another button and then keeps printing the sheet over and over again and i have to cancel all the prints and close excel. Any suggestions!!! the code: " ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "\\server\printer on Ne02:", Collate:=True " cheers -- richardderrick ------------------------------------------------------------------------ richardderrick's Profile: http://www.excelforum.com/member.php...o&userid=34930 View this thread: http://www.excelforum.com/showthread...hreadid=546646 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Marco print issue!!!
There is nothing in the line of code you show that would do what you describe.
Your problem must be elsewhere. -- Regards, Tom Ogilvy "richardderrick" wrote: i have created a marco to be able to print the sheet to a specified printer and i have attached the macro to a button, but when i print it creates another button and then keeps printing the sheet over and over again and i have to cancel all the prints and close excel. Any suggestions!!! the code: " ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "\\server\printer on Ne02:", Collate:=True " cheers -- richardderrick ------------------------------------------------------------------------ richardderrick's Profile: http://www.excelforum.com/member.php...o&userid=34930 View this thread: http://www.excelforum.com/showthread...hreadid=546646 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Macro - PDF Issue | Excel Worksheet Functions | |||
| Marco issue | Excel Discussion (Misc queries) | |||
| Print issue - inconsistent print | Setting up and Configuration of Excel | |||
| Print issue | Excel Discussion (Misc queries) | |||
| Combox/Print issue | Excel Programming | |||
Linear Mode
