| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page setup problems in VBA
Hi All,
I'm trying to copy the page setup (particularly the print area and manual pagebreaks) from a sheet in one book to a number of sheets in another book. When I step through the code, it sets the page breaks and other settings correctly on each sheet, but when I leave the code to run unattended, it doesn't set the pagebreaks correctly. Has anybody come across this before? Does anyone know of a solution? Many thanks, Thinqer. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Page setup problems in VBA
As I recall, when I did this, I had to toggle to Page Break Preview to get
the page breaks to be seen consistently. -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Thinqer" wrote: Hi All, I'm trying to copy the page setup (particularly the print area and manual pagebreaks) from a sheet in one book to a number of sheets in another book. When I step through the code, it sets the page breaks and other settings correctly on each sheet, but when I leave the code to run unattended, it doesn't set the pagebreaks correctly. Has anybody come across this before? Does anyone know of a solution? Many thanks, Thinqer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
| FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
| Page setup problems in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
