FreezePanes

[danusko]

hi all,
i thinking about this. If is possible to create any info about freezing panes.

I mean, when is pan freezed, and rows are scrolled in lower part of table (upper data are not vissible) if is possible display/show any text about this (e.g. "The first line of table are not visible")...but only if is not the upper part of data visible..not always.

thank you

[rwgrietveld]

You could make a textbox and use this code on the sheet that uses the table

Please Login or Register  to view this content.

Note that 5 is arbitrary where you have put your freeze panes.

[danusko]

thx for code..it looks good.
I tried it but it doesnt works.
When i debug code it shows
that this command

Please Login or Register  to view this content.

has always 15
I have freezed panes at rows 14 (14 is freezed and 15th and 16...moves)

I tried change this line

Please Login or Register  to view this content.

to many number 14,15,16,...23(this line is the last what i see on my screen without scrolling).
but nothing.
If is there 14 ..textbox is alway displayed
If is greater then 14, it doesnt appear.

Whats wrong?
I have this code

Please Login or Register  to view this content.

in sheet module

[danusko]

now i figured out, that it works, but only if i after scrolling with mouse wheel, click in somewhere in sheet...after each srolling i have to click on sheet..

is it possible to change it, that it works immediately after scrolling without neccessary to click on sheet?
thx

[rwgrietveld]

This is due to the selection change event.

You can also do it with the calculate or changed event, but this will give you the same result.

Something needs to trigger this code. Application.ontime can do that, but now the code is run every second (e.g.) to check. This can be anoying.

Put this in a module

Please Login or Register  to view this content.

and this in the code of the ThisWorkbook (as a start)

Please Login or Register  to view this content.

[danusko]

ok i understand,
thank you very much for your big help.