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

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/

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?