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

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
>
>