Marco print issue!!!

R

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
 
T

Tom Ogilvy

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

Your problem must be elsewhere.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top