How will the header points more lines show in VBA

Question

hi,
  how will the header points more lines show,if header points more then i need lines show.
I need the following result:
 
the vba code password is :123 
thanks.