check box
 

Hello,
in sheet1 i will create button to print out data in sheet 1 but my

probelm some time i need 2 copy of print so need to make checkbox when

i check checkbox print 2 copy othrwise print 1 copy.

how it possible

check box
 

kalpesh

You have a lot of options. If you sometimes want to print 1 and sometimes want to print 2, you can have two buttons, the code for the second button would be something like

ActiveWindow.SelectedSheets.PrintOut Copies:=2

You could also, go with a single button option, but get the number of copies from a cell or an input. Or you could make a single click of the button print one copy and a double click print two copies. In that case the click code would be your current printing code, and the double click code would be the same, with the modification to have Copies:=2 at the end of the print line.

I hope this helps.

Ken


On Sunday, July 22, 2012 6:18:42 AM UTC-4, kalpesh wrote:
Hello,
in sheet1 i will create button to print out data in sheet 1 but my

probelm some time i need 2 copy of print so need to make checkbox when

i check checkbox print 2 copy othrwise print 1 copy.

how it possible