Perhpas you have beforesave event code that is doing the deed.

Right-click on the Excel Icon left of "File" or at left end of Title Bar if not
maximized.

Select "View Code".

Anything there that looks like it may switch sheets when you hit the save
button?


Gord Dibben MS Excel MVP

On Thu, 3 May 2007 07:21:03 -0700, nvabril
wrote:

When I click the save buttom while working on excel workbook it would take me
to the last spreadsheet in the workbook instead of only saving and staying in
the same sheet that I am on.