Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print
The VB book I have is very limited for excel. Is there a command in which I
can put for my input button that will print the page that I selected?? Thanks.. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print
I'm not sure what you mean by "selected". did you select
it with the mouse? I think i tryed that and ran into problems. I think i it would be best to have the code select the print area but you gave no data structure so i don't know really. but here is some code i use to select and print. Range("A1").Select Selection.CurrentRegion.Select ActiveWorkbook.Names.Add Name:="PrintStuff", _ RefersTo:=Selection, Visible:=True ActiveSheet.PageSetup.PrintArea = "PrintStuff" 'ActiveWindow.SelectedSheets.PrintPreview 'ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True the printpreview line and printout line are commented out here. use when ever one you want. -----Original Message----- The VB book I have is very limited for excel. Is there a command in which I can put for my input button that will print the page that I selected?? Thanks.. Michael . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Error Message: Print titles must be contiguous and complete | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions |