Freeze Pane indicator

[Glenn]

Hi,

Has anyone a way to indicate if data is hidden when you scroll down using Freeze Pane please?

My first 5 rows are frozen and I was thinking it would be great if something appeared (a red arrow pointing upwards) on the frozen rows when you scroll down.

This is just to indicate that there is data hidden.

Thanks, Glenn.

 

[mikerickson]

Hmm..One method might be to make a very thick upper border on the top un-frozen row. (No thick top=hidden data)

This UDF will return whether there is hidden data, but I can't seem to get it to work (smoothly) with Conditional Formatting or on the spreadsheet. What event is triggered by scroll-down?

Function scrolledDown() As Boolean
Application.Volatile
With ActiveWindow
    scrolledDown = Not (.Panes(1).VisibleRange.Rows.Count + 1 = .Panes(2).VisibleRange.Row)
End With
End Function

 

[Glenn]

Thanks mikerickson,

I'll give it a go.

I was thinking turning on and off an Autoshape - Block Arrow.

ie: when the window is scrolled down, the arrow appears, if the window is scrolled back to normal, it disappears.

Cheers, Glenn

 

[mikerickson]

The trick is letting the computer know when a window is scrolled. Changeing cell contents triggers Change events and spreadsheet formulas. But scrolling is deeper in the code than spreadsheet changes.

 

[Glenn]

The trick is letting the computer know when a window is scrolled.

Yes, realized I didn't answer the most important "event" question above.

I tried the code you posted and works really well. Problem is as you mention, how to trigger it. I suppose I was thinking scrolling would but I bet the is no scroll event!

Thanks for your help Mike I might stick with just scrolling to the top on worksheet activate. If someone can't find their data, they will when changing sheets :P

Cheers Glenn