Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Print Area
I have a workbook with 12 worksheets in it. They are all basically the same
so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Print Area
Try this subroutine
Sub Macro1() For Each ws In Worksheets ws.Select ActiveSheet.PageSetup.PrintArea = "$A$1:$E$20" Next End Sub Let me know if you need help adding a macro best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I have a workbook with 12 worksheets in it. They are all basically the same so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Print Area
Yes, I do. I don't have a clue how to do this.
"Bernard Liengme" wrote: Try this subroutine Sub Macro1() For Each ws In Worksheets ws.Select ActiveSheet.PageSetup.PrintArea = "$A$1:$E$20" Next End Sub Let me know if you need help adding a macro best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I have a workbook with 12 worksheets in it. They are all basically the same so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Print Area
With you workbook open use the command Tools | Macro | Visual Basic Editor
In the Edit use Insert | Module Now copy and paste my module to the main window in the Editor Is some lines get split into two in the email, carefully use delete/backspace to fix. The longest line is ActiveSheet.PageSetup.PrintArea = "$A$1:$E$20" and should appear as one line Return to the worksheet; Use Tools | Macro | Macros and click on TryThis best wishes (don't be afraid to ask for clarification) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... Yes, I do. I don't have a clue how to do this. "Bernard Liengme" wrote: Try this subroutine Sub Macro1() For Each ws In Worksheets ws.Select ActiveSheet.PageSetup.PrintArea = "$A$1:$E$20" Next End Sub Let me know if you need help adding a macro best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I have a workbook with 12 worksheets in it. They are all basically the same so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003: Print Area
Oops, my macro is called Macro1 so click on in last step!
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... Yes, I do. I don't have a clue how to do this. "Bernard Liengme" wrote: Try this subroutine Sub Macro1() For Each ws In Worksheets ws.Select ActiveSheet.PageSetup.PrintArea = "$A$1:$E$20" Next End Sub Let me know if you need help adding a macro best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "oceanmist" wrote in message ... I have a workbook with 12 worksheets in it. They are all basically the same so when I set the print area for one it could be the same for all 12 worksheets. Is there a way to do this all at once rather than 12 times? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upgrade to Excel 2003 -Will not print! | New Users to Excel | |||
print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
set print area icon in Excel | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) |