| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to copy all print settings to all sheets
I have a workbook that has several hundred sheets, that all need exactly the same print settings. Is there a way to set up one sheet with page breaks, margins, print compression, rows repeated at top, headers, footers, etc.. and copy those to each sheet in the workbook? -- rbanks ------------------------------------------------------------------------ rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944 View this thread: http://www.excelforum.com/showthread...hreadid=521754 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to copy all print settings to all sheets
Hello rbanks
AFAIK apart from looping through each worksheet? Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets With wsh.PageSetup ..CenterFooter ..LeftMargin ..PrintArea ..PrintTitleRows 'so on... End With Next wsh HTH Cordially Pascal "rbanks" a écrit dans le message de news: ... I have a workbook that has several hundred sheets, that all need exactly the same print settings. Is there a way to set up one sheet with page breaks, margins, print compression, rows repeated at top, headers, footers, etc.. and copy those to each sheet in the workbook? -- rbanks ------------------------------------------------------------------------ rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944 View this thread: http://www.excelforum.com/showthread...hreadid=521754 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to copy all print settings to all sheets
Hello I think this link will help - in it is a fantastic tool to copy print
settings also you will find many other great time savers. I have used for many years and on many different machines and environments - never had an issue. the link - http://www.asap-utilities.com/ - it is free "rbanks" wrote: I have a workbook that has several hundred sheets, that all need exactly the same print settings. Is there a way to set up one sheet with page breaks, margins, print compression, rows repeated at top, headers, footers, etc.. and copy those to each sheet in the workbook? -- rbanks ------------------------------------------------------------------------ rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944 View this thread: http://www.excelforum.com/showthread...hreadid=521754 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to copy all print settings to all sheets
Thanks, worked like a charm. -- rbanks ------------------------------------------------------------------------ rbanks's Profile: http://www.excelforum.com/member.php...fo&userid=2944 View this thread: http://www.excelforum.com/showthread...hreadid=521754 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consistent print settings across multiple sheets | Excel Discussion (Misc queries) | |||
| How do I copy the print settings, including header and footer fro. | Excel Discussion (Misc queries) | |||
| How do I copy the print settings from one worksheet to another? | Excel Discussion (Misc queries) | |||
| How do I apply the same print settings to all sheets in a workbk | Excel Discussion (Misc queries) | |||
| Copy WorkSHeet To New Book With Print Page Settings ? | Excel Programming | |||
![rbanks[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
