Marco print issue!!!

[richardderrick]

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

 

[Guest]

There is nothing in the line of code you show that would do what you describe.

Your problem must be elsewhere.