Dual Freeze panes

[Debraj]

Hi Gurus,


Lets have a fight with WINDOWS Object..


* Worksheet's Structure

Something like

[pre]

******	Col 2	        Col 3	        Col 25	        Sum Column
Row 2	0.440345812	0.91396172	0.497156207	2 Row
Row 3	0.880934126	0.47006482	0.839687197	3 Row
Row 99	0.071573223	0.612800147	0.670963516	99 Row
Sum Row	2 Col	        3 Col	        25 Col	        ******[/pre]
where From (Row 4 to row 98) and (Col 4 to Col 24) are hidden only in this post for posting purpose, not in the sheet.. 


I need

* One Freeze Pane at B2 so that (Col 2 to Sum Column) and (Row 2 to Sum Row) (+x,-y area in [url=http://http://en.wikipedia.org/wiki/Cartesian_coordinate_plane#Cartesian_coordinates_in_two_dimensions]Cartesian table[/url]) area always visible.

and

* another (virtual) Freeze Pane at Z100, so that (Col Z and Row 100) (-x,+y area in [url=http://http://en.wikipedia.org/wiki/Cartesian_coordinate_plane#Cartesian_coordinates_in_two_dimensions]Cartesian table[/url]) is always visible..


* Ir-respective of Monitor Size / Window State... according to the [code]ActiveSheet.VisibleRange need to decide how many (EntireColumn and EntireRow)

need to be .Hidden = (True / False)[/code] so that OuterBorder in all side is always visible, according to the Target.Cell.


* Dont worry about 100 + Rows and 26 + Column, they are already Hidden.


I hope I made the requirement Clear, so that you don't have to open the attached sheet..

https://dl.dropbox.com/u/78831150/Excel/Dual%20Freeze%20Pane.xlsm


With lots of Thanks in Advance,

Regards,

Deb

 

[SirJB7]

Hi, Debraj Roy!

Mi first & short comment as I'm in a hurry:

http://chandoo.org/forums/topic/displaygridlines-property#post-37587

Regards!

PS: I don't like Windows object