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

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