Can't Scroll back to top

**witecoko** · 12-26-2008, 11:29 AM

I have a spreadsheet with some scripting that automatically emails the report to whoever is on the sheet. I'm not sure what kind of scripting it is. I think my boss found it somewhere. I was hoping someone could help me with an issue I have been having.

Whenever I scroll either down or up, the first 3 rows disappear and I'm not able to scroll back up. The scrollbar shows that I'm not at the top, but it won't let me go back up. The first 3 rows contain the button to send the email. If I close out without saving and open it again, its fine, until I scroll up or down.

I have tried to see if they are frozen or hidden, and they are not. I hope I have explained it well enough. I can send the file to anyone if you would like. Any help would be appreciated. Thanks.

**shg** · 12-26-2008, 11:35 AM

Welcome to the forum.

Sure, post the workbook.

**witecoko** · 12-26-2008, 11:44 AM

Thanks for the welcome. Here is the spreadsheet.

**davesexcel** · 12-26-2008, 11:58 AM

You have this code in the worksheet module

Please Login or Register  to view this content.

Right click on the sheet tab,select view code, find the code and set the A6 to A1

**witecoko** · 12-26-2008, 12:07 PM

Thank you! This solved it, and I learned something new too!

**pablo_g** · 01-17-2012, 01:11 PM

Hi,
I am having the same issue in Excel 2010. I cant scroll to the upper portions of my worksheet (I have tried the obvious solution of 'unhide'). It appears a number of rows have disappeared, although the scrollbar shows that I am not at the top of the page.
Oddly enough, some of the row numbers on the left have turned blue where I can't scroll any higher.

Any solutions would be appreciated!

Paul