Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting automatic page breaks in excel 2003
Hello,
I have a problem concerning deleting automatic page breaks in excel 2003. I found this code in a previous discussion: Sub DeleteHPageBreaks() Dim pb As HPageBreak Dim lCount As Long For lCount = Sheet1.HPageBreaks.Count To 1 Step -1 Set pb = Sheet1.HPageBreaks(lCount) If pb.Type = xlPageBreakAutomatic Then pb.Delete Next lCount End Sub The code seems to work fine in previous excel versions, but not in 2003. Does anyone know how to solve this in excel 2003? I would appreciate your help! /Malin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting automatic page breaks in excel 2003
Deleting automatic pagebreaks is pretty much meaningless.
Just set displaypagebreaks to false and it will be just as effective. -- Regards, Tom Ogilvy "mLinn" wrote: Hello, I have a problem concerning deleting automatic page breaks in excel 2003. I found this code in a previous discussion: Sub DeleteHPageBreaks() Dim pb As HPageBreak Dim lCount As Long For lCount = Sheet1.HPageBreaks.Count To 1 Step -1 Set pb = Sheet1.HPageBreaks(lCount) If pb.Type = xlPageBreakAutomatic Then pb.Delete Next lCount End Sub The code seems to work fine in previous excel versions, but not in 2003. Does anyone know how to solve this in excel 2003? I would appreciate your help! /Malin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When automatic page breaks are moved each cell becomes a new page | Excel Discussion (Misc queries) | |||
how can i delete automatic page breaks in excel | New Users to Excel | |||
deleting automatic page breaks | Excel Worksheet Functions | |||
Automatic page breaks in Excell 2003 | Excel Discussion (Misc queries) | |||
How do I stop automatic page breaks in excel | Excel Worksheet Functions |