Hello. I wrote this for myself today and decided to share it. Most of it is "original" but part of the letter to number conversion I found and incorporated.

It loops through all the sheets and freezes the panes according to the user input. I made it so the column input will work with either a number or letter (nice, eh? ). The code is written to handle to column ZZZ but after I went to the trouble I noticed Excel doesn't recognize anything beyond 511 (column SQ)...not that there should be any need to go anywhere near that far anyway. Inputting zero for both inputs will unfreeze all panes.

Enjoy.



Please Login or Register  to view this content.