Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
I've attached Macro to a Command Button in one worksheet called
"Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
Worksheets("Summary").range("a1:a43").PrintOut _
Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
add
Worksheets("Summary").PrintArea = "$A$1:$A$43" "Garyw" wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
Dave
When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
you need to select something after you inserted the picture
try cells(1,1).select "Garyw" wrote: Dave When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
Did you put the second picture in A1:A43?
If you test it manually select a1:a43 file|print|Selection|Print preview do you see both pictures? Did you change one of the picture's properties so that it wouldn't print? Garyw wrote: Dave When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
When I print this range manually it prints fine.
When I use the command button it gives a preview of only one picture on the page. -- Garyw "Dave Peterson" wrote: Did you put the second picture in A1:A43? If you test it manually select a1:a43 file|print|Selection|Print preview do you see both pictures? Did you change one of the picture's properties so that it wouldn't print? Garyw wrote: Dave When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
I don't have another guess.
Garyw wrote: When I print this range manually it prints fine. When I use the command button it gives a preview of only one picture on the page. -- Garyw "Dave Peterson" wrote: Did you put the second picture in A1:A43? If you test it manually select a1:a43 file|print|Selection|Print preview do you see both pictures? Did you change one of the picture's properties so that it wouldn't print? Garyw wrote: Dave When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print from Command Button Range
Dave
I selected and named the print range "PrintRange" and changed it in the formula. It worked like a charm. Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("PrintRange").PrintOu t _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: I don't have another guess. Garyw wrote: When I print this range manually it prints fine. When I use the command button it gives a preview of only one picture on the page. -- Garyw "Dave Peterson" wrote: Did you put the second picture in A1:A43? If you test it manually select a1:a43 file|print|Selection|Print preview do you see both pictures? Did you change one of the picture's properties so that it wouldn't print? Garyw wrote: Dave When I press the Command Buttom the print preview only shows one of the pictures I inserted into to worksheet named "CutSheet". No text etc. The code is as follows: Private Sub CommandButton1_Click() Worksheets("CutSheet").Range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=True End Sub -- Garyw "Dave Peterson" wrote: Worksheets("Summary").range("a1:a43").PrintOut _ Copies:=1, Collate:=True, preview:=true (Preview:=true will save a few trees when you're testing.) Garyw wrote: I've attached Macro to a Command Button in one worksheet called "Worksheet"which I need to print a range in another worksheet called "Summary". I have so far this line: Worksheets("Summary").PrintOut Copies:=1, Collate:=True Where do I add the range A1:A43? Garyw -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button print | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
command button in excel will move when print. | Excel Discussion (Misc queries) | |||
How do I setup a print command button in excel 2003 | New Users to Excel |