| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove print area from multiples pages
I have a workbook with 183 pages and need to remove print areas from all
pages. Is there a way to do this all at once? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove print area from multiples pages
Maybe you could use a macro:
Option Explicit Sub testme() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets wks.PageSetup.PrintArea = "" Next wks End Sub If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Linda wrote: I have a workbook with 183 pages and need to remove print areas from all pages. Is there a way to do this all at once? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
| Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
| Remove from Print Area | Excel Discussion (Misc queries) | |||
| Set print area on several pages at once in Excell Workbook? | Excel Discussion (Misc queries) | |||
| Print area will only go up to 101 pages | Excel Discussion (Misc queries) | |||
Linear Mode
