Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Loop through column(s) to check values, perform action based on check | Excel Programming | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) |