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

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 w=
ould be something like

ActiveWindow.SelectedSheets.PrintOut Copies:=3D2

You could also, go with a single button option, but get the number of copie=
s 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:=3D2 at the end of the pr=
int line.

I hope this helps.

Ken