VBA:Showing Header Table Like Freeze Panes in Excel

Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

VBA:Showing Header Table Like Freeze Panes in Excel

Post by Susanto3311 »

hi all.

i have word document contains table and text with over 9 pages.
how to edit /update table with easy, cause since i go down to page 2, 3,4, etc...that make confuse cause the header not always showing.
how to make header always showing like Freeze Panes in Excel to be "helper" inputting data or how to tricks for this case
here the attachment file
maybe this step:
1. select range that you want to be header;
2. run macro, like "Freeze Panes" is showing
the header is blue shading

anyone help me, thanks in advance

.susant
You do not have the required permissions to view the files attached to this post.

User avatar
StuartR
Administrator
Posts: 12604
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: VBA:Showing Header Table Like Freeze Panes in Excel

Post by StuartR »

You already have "Repeat header rows" set so that this table head will appear on every page.
You might be able to achieve what you want by moving the table header to the top of the screen and using View > Split to create a separate pane that has just the table headers at the top of the screen.
You do not have the required permissions to view the files attached to this post.
StuartR


Susanto3311
3StarLounger
Posts: 240
Joined: 17 Feb 2022, 05:16

Re: VBA:Showing Header Table Like Freeze Panes in Excel

Post by Susanto3311 »

hi StuartR...
thank you so much!