Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop view and lock columns | Excel Worksheet Functions | |||
How to compress rows and lock rows | Excel Discussion (Misc queries) | |||
lock column size for some rows and resize for other rows. | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Can I lock rows? | Setting up and Configuration of Excel |