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.
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.
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks