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