I hear what you're saying, but I don't think that's the end of the story.

Think of it this way... if you have one workbook, with 10 sheets, and you
have the FreezePanes set on sheet 2, but not any other...

if you click any sheet but sheet 2, the FreezePanes is false, but if you
click on sheet 2, FreezePanes is true.

All in ONE window.

Hence, it is (or should be) also a property of the worksheet.


"NickHK" wrote:

Mark,
If you make another window (WindowsNew) then arrange them so you see both
simultaneously.
Now freeze the panes somewhere on the active window.
You will see the other window is not affected.
Hence it is not a Worksheet property, but a property of the Window.
As you normally only have a single window/workbook, you tend not to notice
this behaviour.

NickHK

"mark" ...
I was just logging in to ask a question about FreezePanes... will just
append
it here.

I know that that's the way it's designed and written, etc...

But, logically, is there an explanation that someone can give to me why
FreezPanes is a property of the Window object, and not of the Worksheet
object?

Maybe I'm just missing it.

Thanks.