VBA Print code?????

[Chris Watson]

Can anybody give me the VBA code for a command button that will print the active worksheet and also give the user the option to select how many.

[Duke Carey]

very simplistic

Dim i As Integer

i = InputBox("How many copies")
ActiveSheet.PrintOut copies:=i


"Chris Watson" wrote:

>
> Can anybody give me the VBA code for a command button that will print
> the active worksheet and also give the user the option to select how
> many.
>
>
> --
> Chris Watson
> ------------------------------------------------------------------------
> Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
> View this thread: http://www.excelforum.com/showthread...hreadid=525646
>
>