Deleting automatic page breaks in excel 2003

M

mLinn

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
 
T

Tom Ogilvy

Deleting automatic pagebreaks is pretty much meaningless.

Just set displaypagebreaks to false and it will be just as effective.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding page breaks conditionally 1
Deleting HPageBreaks returns... 6
Add page breaks after a certain number of cells in a column meet acondition 0
problem with finding horizontal page breaks 7
Follow up question. Get value of closed file. 5
Problem when copying a range from closed workbooks (ADO) 4
Finding automatic page breaks in new, blank worksheet 1
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook using ADO 2

Top