Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
scrolling through rows
I have a problem, I am wanting to scroll through about 20 rows only, and the remained ie aboveand below those 20 rows will remain visible. Using the freeze panes workes, but leaves a nasty line on the screen and I have tried to use a vb scrollbar on the sheet, this when clicked hides the first line and unhides the last line, thus giving the illusion of the rows moving up and down the sheet. This works, but there is a lot of flickering.
My question is two fold, 1) can you hide the freeze pans line on the screen? 2) can you aviod the flicker on the scroll bar? I will provide coding if necessary. I hope someone can help as this is a key point for my spreadsheets. Thanks in advance Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
scrolling through rows
Jason,
afaik the freeze lines cannot be altered. could you mail existing book (addr below), i'll see what can be done with the flickering :) keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool ?B?SmFzb24gQXNodG9u?= wrote: I have a problem, I am wanting to scroll through about 20 rows only, and the remained ie aboveand below those 20 rows will remain visible. Using the freeze panes workes, but leaves a nasty line on the screen and I have tried to use a vb scrollbar on the sheet, this when clicked hides the first line and unhides the last line, thus giving the illusion of the rows moving up and down the sheet. This works, but there is a lot of flickering. My question is two fold, 1) can you hide the freeze pans line on the screen? 2) can you aviod the flicker on the scroll bar? I will provide coding if necessary. I hope someone can help as this is a key point for my spreadsheets. Thanks in advance Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show top three rows when scrolling | New Users to Excel | |||
How to fix the top-most 4 rows when scrolling? | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
excessive rows when scrolling down | Excel Worksheet Functions | |||
lock-out rows from scrolling | Excel Programming |