ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Worksheet does not open in the last place it was saved (https://www.excelbanter.com/excel-worksheet-functions/146743-worksheet-does-not-open-last-place-saved.html)

LDurham

Worksheet does not open in the last place it was saved
 
When I save my worksheet and then reopen it jumps back to the beginning of
the sheet, not where I saved it last
Help

Vasant Nanavati

Worksheet does not open in the last place it was saved
 
Are you sure there is no macro tied to the Open or BeforeClose events that
does this?
__________________________________________________ _______________________

"LDurham" wrote in message
...
When I save my worksheet and then reopen it jumps back to the beginning of
the sheet, not where I saved it last
Help




Gord Dibben

Worksheet does not open in the last place it was saved
 
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

On Sat, 16 Jun 2007 04:48:00 -0700, LDurham
wrote:

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



LDurham

Worksheet does not open in the last place it was saved
 
No macro's attached.. I checked

"Vasant Nanavati" wrote:

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

"LDurham" wrote in message
...
When I save my worksheet and then reopen it jumps back to the beginning of
the sheet, not where I saved it last
Help






All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com