Freeze Panes

S

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!)
 
D

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
 
Top