the printout command has a copies argument. You can query the user for the
number of copies, then pass that as a variable to the printout command
copies argument.

--
Regards,
Tom Ogilvy

"Mald" wrote in message
...
I want a macro to print a worksheet with the provision to user define the
number of copies

thank you

Mald