How to lock the view of certain number of rows

  • Thread starter Thread starter sameerce
  • Start date Start date
S

sameerce

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
 
Hi
locate the cursor in cell A6 and goto 'Windows - Freeze Panes'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find Date in range and scroll down to next row 2
Trying to freeze heading rows on a sheet 5
Getting to the right worksheet 2
Can anybody get this code to perform on the correct worksheet? 7
Excel not showing steps as I F8 through each line of VBA code 1
2002 vs 2007 MS Office Excel has encountered a problem and needs t 2
Locking the view of Excel sheet 10
Excel 2003 macro won't run in Excel 2007 5

Back
Top