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

Similar Threads

Problem with printing a word document containing a table 0
How to print an A4 document to 2 A5s 0
Table of content - format does not get saved 2
Print to PDF format 4
Simple Macro freezes the whole Excel and PC! 5
NetWork Printer Selection Problems 1
Shift Collate sheet 1-20 when printing entire workbook? 0
Creating PDF files via 995 1

Top