Freeze Pane indicator

Glenn

Active Member
Joined
Sep 20, 2003
Messages
325
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.
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,901
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?
Code:
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

Active Member
Joined
Sep 20, 2003
Messages
325
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,901
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

Active Member
Joined
Sep 20, 2003
Messages
325
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top