Print Command Button for other sheets

[baljit007]

Please assist/advice how I create a command button - to directly print the selected sheet - but prompt message to ask how many pages/copies to be printed.

Example - The names of the sheets are, "Green" , "Yellow" and "Brown" Command button will directly print the sheet - If button is named Green, will print Green sheet - but when clicked, it prompts message to ask how many pages/copies, and then proceed to print the sheet and its required copies

Thanks
REPLY

 

[vletm]

baljit007
Even this would do those ...
... but there would be many things which would do error! = Need to use correct way