Forum Discussion
Screen not scrolling down
Sue Perhaps "Freeze Panes" has been set outside the view of your window. Try unfreezing panes.
Sue Perhaps "Freeze Panes" has been set outside the view of your window. Try unfreezing panes.
Thank you Riny. I "unfroze all" in sheets 2 and 3, then froze the first row, (which is the heading), manually. The sheets then worked normally as sheet 1. I have no idea how, or when, sheets 2 and 3 got frozen - particularly out of sight of screen view (I don't even know how to do that) particularly as the sheets are only used with the form! The program used on the sheets worked normally on all of them with the exception of the PageUp, PageDown on sheets 2 and 3 - the code must over-ride the display except for those particular commands. I realized however that scrolling really needs to be YearUp and YearDown as the amount of data in a Year is less rows than a full screen. I have put that on the to-do list!
I am not sure how this messaging works. I sent a reply to you much as I have just typed above but the record on my screen appeared that I sent you a blank message! If so I apologize or alternatively apologize for sending a repeat! Sue
Sue Glad it works now!