File opens to G1, unable to cursor left to A1

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

Hey folks, super odd. I have a 12 sheet document to edit, the author
left for a week, I can't get to A1 except to plug it into the Name
Box. Then the address bar will show me the text IN A1, but the screen
won't go past G1, the screen view will only show anything to the right
of column G. If I hit the right cursor, it jumps to G1, bypassing B-F1
entirely.

I can cut and paste each sheet into a new document successfully (which
will take the rest of my life) but I know it's cause I'm ignorant of
something. But what? Any takers? thanks. (BTW, happens on 3 different
machines and 2 platforms, so I know it's something imbedded in the
document)

-Rudy
 
Rudy

Are you saying you can't see columns A through F? Perhaps they are hidden?

Hit CRTL + A and right-click on any column heading. Choose "unhide".

If you can see A through F but can't get there you might have a WorkBook_Open
macro that limits the scroll area.

Hit ALT + F11 to get to the Visual Basic Editor. Find you workbook/project by
name and left-click to select it. Expand using the + button.

Double-click on the ThisWorkbook module and see if there is any code that
looks like this.....

WorkBook_Open()
For Each ws In ActiveWorkbook.Sheets
ws.ScrollArea = "g1:iv65536"
Next ws
End Sub

Also see if there is an Auto-Open Sub in any module.

Gord Dibben XL2002
 
It could be a hidden row or column.

When you get to A1, try Format|Row|unhide (and column, too).

If that wasn't it, try Window|Unfreeze Panes.

(sometimes the freezepanes is set so you can't get to the left hand side.)
 
Back
Top