I have a workbook that multiple users access on a daily basis. When the workbook is opened, I use "Sub Workbook_Open()" to select a certain cell at the top-left of the sheet so that the top-left area of the worksheet is always displayed. Recently, when opening the file AND even with that cell selected, the viewing area has been half-way down the sheet length...yet the correct cell is still selected. Is there any way to tell excel to always view top-left most area of the worksheet? It's like someone selected the correct cell, scrolled half-way down the sheet and saved the workbook. I would still think though, when "Sub Workbook_Open()" runs, the viewing area would move back up to the top-left (but it doesn't!!). I tried to google this but couldn't find anything useful. Has anyone else ever run into this? Thanks so much!
Bookmarks