Freeze Panes

[Stewart Walker]

I would like to know if it's possible to freeze panes
without the 'freeze panes lines' appearing on the screen...

TIA

Stewart
MOS Excel Expert (not good enough though!)

 

[Don Guillett]

You might try this. In this instance you would want to place cursor at c7
first.
Sub setarea()
ActiveSheet.ScrollArea = "$b6:h14"
'ActiveSheet.ScrollArea = "" 'to reset
End Sub

 

[Gord Dibben]

Stewart

Not possible.

Gord Dibben Excel MVP