Page Border in protected Excel Worksheet at PageBreak

[Imran786]

I have a protected worksheet. When I print it, the border at Page Break is not continuous. It breaks at the columns J, K and L.

I have automated the columns J, K and L to merge based on the selection in column H and the VBA code is placed In the same sheet with WorkSheetChange event.

Let me know how can I get continuous border at Page Break?

[#2]

Excel does not display any borders within merged cells. You have two options: Accept that limitation, or unmerge the cells.

[#3]

Dear Jan,

I have merged the cells and want the borders around the merged cells. The problem is only at the page break (where there are no merged cells and bottom borders are not shown) and not elsewhere in the page where I get all borders around the merged cells.