Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Is there a way to totally remove the print area from a worksheet?
I have a financial spreadsheet that people download from the internet and I want to simplify the printing process by "tagging" selected worksheets to print and others not to print. Note: I wish for this to happen automatically...i.e. - without the user having to input page numbers in the print dialog or "Ctrl + selecting worksheets". Can anyone help? dwadholm |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Sub printsheets()
Sheets("sheet1").Range("a2:c5").Printout 'Preview Sheets("sheet2").Range("a4:d15").Printout 'Preview 'etc End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "dwadholm" wrote in message ... Is there a way to totally remove the print area from a worksheet? I have a financial spreadsheet that people download from the internet and I want to simplify the printing process by "tagging" selected worksheets to print and others not to print. Note: I wish for this to happen automatically...i.e. - without the user having to input page numbers in the print dialog or "Ctrl + selecting worksheets". Can anyone help? dwadholm |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Thanks...but I am only formula saavy not tech/programming saavy. Where do I
place the code you provided/ dwadholm "Don Guillett" wrote: Sub printsheets() Sheets("sheet1").Range("a2:c5").Printout 'Preview Sheets("sheet2").Range("a4:d15").Printout 'Preview 'etc End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "dwadholm" wrote in message ... Is there a way to totally remove the print area from a worksheet? I have a financial spreadsheet that people download from the internet and I want to simplify the printing process by "tagging" selected worksheets to print and others not to print. Note: I wish for this to happen automatically...i.e. - without the user having to input page numbers in the print dialog or "Ctrl + selecting worksheets". Can anyone help? dwadholm |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
I think Don meant to say this macro would be pasted into a general module, not
Thisworkbook module. A great site for learning where to enter different types of code can be found at Ron de Bruin's pages. http://www.rondebruin.nl/code.htm Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 10:23:18 -0500, "Don Guillett" wrote: One way. Alt f11copy/paste into the ThisWorkbook modulemodify to suitSAVE the workbook. To execute assign to a button/shape or just use alt f8this workbookrun If you're new to macros, you may want to read David Ritchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "dwadholm" wrote in message ... Thanks...but I am only formula saavy not tech/programming saavy. Where do I place the code you provided/ dwadholm "Don Guillett" wrote: Sub printsheets() Sheets("sheet1").Range("a2:c5").Printout 'Preview Sheets("sheet2").Range("a4:d15").Printout 'Preview 'etc End Sub |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Thanks...I will check these out.
dwadholm "Gord Dibben" wrote: I think Don meant to say this macro would be pasted into a general module, not Thisworkbook module. A great site for learning where to enter different types of code can be found at Ron de Bruin's pages. http://www.rondebruin.nl/code.htm Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 10:23:18 -0500, "Don Guillett" wrote: One way. Alt f11copy/paste into the ThisWorkbook modulemodify to suitSAVE the workbook. To execute assign to a button/shape or just use alt f8this workbookrun If you're new to macros, you may want to read David Ritchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "dwadholm" wrote in message ... Thanks...but I am only formula saavy not tech/programming saavy. Where do I place the code you provided/ dwadholm "Don Guillett" wrote: Sub printsheets() Sheets("sheet1").Range("a2:c5").Printout 'Preview Sheets("sheet2").Range("a4:d15").Printout 'Preview 'etc End Sub |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Gord,
Didn't want to confuse him if he didn't have or know how to create a general module. Tested in the ThisWorkbook OK. -- Don Guillett Microsoft MVP Excel SalesAid Software "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I think Don meant to say this macro would be pasted into a general module, not Thisworkbook module. A great site for learning where to enter different types of code can be found at Ron de Bruin's pages. http://www.rondebruin.nl/code.htm Gord Dibben MS Excel MVP On Tue, 16 Oct 2007 10:23:18 -0500, "Don Guillett" wrote: One way. Alt f11copy/paste into the ThisWorkbook modulemodify to suitSAVE the workbook. To execute assign to a button/shape or just use alt f8this workbookrun If you're new to macros, you may want to read David Ritchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Don Guillett Microsoft MVP Excel SalesAid Software "dwadholm" wrote in message ... Thanks...but I am only formula saavy not tech/programming saavy. Where do I place the code you provided/ dwadholm "Don Guillett" wrote: Sub printsheets() Sheets("sheet1").Range("a2:c5").Printout 'Preview Sheets("sheet2").Range("a4:d15").Printout 'Preview 'etc End Sub |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Print Area
Thanks Don.
Gord On Tue, 16 Oct 2007 13:54:25 -0500, "Don Guillett" wrote: Gord, Didn't want to confuse him if he didn't have or know how to create a general module. Tested in the ThisWorkbook OK. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
File, print area, clear area, is not working | New Users to Excel | |||
print area across the freeze panes area | Excel Worksheet Functions | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) |