Forum Discussion

Imran786's avatar
Imran786
Copper Contributor
Oct 28, 2021

Page Border in protected Excel Worksheet at PageBreak

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 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 02, 2021
    Excel does not display any borders within merged cells. You have two options: Accept that limitation, or unmerge the cells.
    • Imran786's avatar
      Imran786
      Copper Contributor
      Nov 15, 2021
      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.

Resources