View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sameerce[_12_] sameerce[_12_] is offline
external usenet poster
 
Posts: 1
Default How to lock the view of certain number of rows

Hi,
I have developed an Excel VBA application where there are certain
hyperlinks in the rop 5 rows that helps in browsing between sheets. I
want this rows to be visible even when the user scrolls down on that
sheet. Right now what happens is on scrolling down that part is not
visible and one has to scroll up again.

Thus, for ease of browsing between the sheets, that top part of the
sheet should always be visible and the remaining part should scroll
down.

Can anyone suggest any way to achieve this either programatically or
directly.

Thanks
Sameer


---
Message posted from http://www.ExcelForum.com/