Prev: Error when Saving a Workspace
Next: Printing Problem
From: Linda on 8 Apr 2010 12:21
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?
From: Dave Peterson on 8 Apr 2010 13:21
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 here:
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
 | 
Pages: 1
Prev: Error when Saving a Workspace
Next: Printing Problem