Worksheet does not open in the last place it was saved

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LDurham - 16 Jun 2007 12:48 GMT

When I save my worksheet and then reopen it jumps back to the beginning of
the sheet, not where I saved it last
Help

Reply to this Message

Vasant Nanavati - 16 Jun 2007 16:09 GMT

Are you sure there is no macro tied to the Open or BeforeClose events that
does this?
_________________________________________________________________________

> When I save my worksheet and then reopen it jumps back to the beginning of
> the sheet, not where I saved it last
> Help

Reply to this Message

LDurham - 18 Jun 2007 18:51 GMT

No macro's attached.. I checked

> Are you sure there is no macro tied to the Open or BeforeClose events that
> does this?
[quoted text clipped - 3 lines]
> > the sheet, not where I saved it last
> > Help

Reply to this Message

Gord Dibben - 16 Jun 2007 16:22 GMT

I would suggest you have some code that does the deed.

Alt + F11 to open VB Editor

Look for a general module with an Auto-Open sub or look in Thisworkbook for a
Workbook_Open sub.

As an aside...........you cannot save a worksheet.........only a workbook which
contains one or more worksheets.

Gord Dibben MS Excel MVP

>When I save my worksheet and then reopen it jumps back to the beginning of
>the sheet, not where I saved it last
>Help

Reply to this Message