Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi. Is it possible to save each page in the page break view in a new
workbook? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could start with Ron de Bruin's macro:
http://www.rondebruin.nl/hpagebreaks.htm If you really want a new workbook, then I think (untested) that you'll have to make a change. Change this section: With Asheet.Parent Set Nsheet = Worksheets.Add(after:=.Sheets(.Sheets.Count)) End With to Set Nsheet = workbooks.add(1).Worksheets(1) tc wrote: Hi. Is it possible to save each page in the page break view in a new workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove big gray page number on Page Break Preview??? | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
Hiding the page number in page break preview background. | Excel Discussion (Misc queries) | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |