| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy all pagesetup settings?
Hopefully a question with a simple answer (that's how they al
start)... In VBA is it possible to copy all of the pagesetup setting (printareas, margins, headers footers... everything) from a sheet i one workbook to a sheet in another workbook -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy all pagesetup settings?
No simple answer
Read this answer from Dave Peterson http://tinyurl.com/3y2uc -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "cornishbloke " wrote in message ... Hopefully a question with a simple answer (that's how they all start)... In VBA is it possible to copy all of the pagesetup settings (printareas, margins, headers footers... everything) from a sheet in one workbook to a sheet in another workbook? --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy all pagesetup settings?
Very simple answer: You need to copy the settings property by
property. Alternative: copy the entire sheet - page setup settings go along for the ride. OTOH, accessing the PageSetup object property by property can be glacially slow, so you might want to take a look at http://www.mcgimpsey.com/excel/pagesetup.html which has a macro based on a routine by John Green (which you can see he http://google.com/groups?selm=VA.000...28c7e5%40mara9 In article , cornishbloke wrote: Hopefully a question with a simple answer (that's how they all start)... In VBA is it possible to copy all of the pagesetup settings (printareas, margins, headers footers... everything) from a sheet in one workbook to a sheet in another workbook? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I copy my protection settings from 1 workbook to another? | Excel Worksheet Functions | |||
| Is there a way to 'copy' my XL settings to another PC? | Excel Discussion (Misc queries) | |||
| How do I copy the print settings from one worksheet to another? | Excel Discussion (Misc queries) | |||
| How to copy toolbar settings from Excel 2003? | Excel Discussion (Misc queries) | |||
| How can I copy page setup settings to other worksheets? Thanks | Excel Discussion (Misc queries) | |||
![cornishbloke[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
