View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default how do i save file to show current worksheet

Hi,

It should take you back to the worksheet and cell that were active when
saved and if it doesn't then a macro is redirecting it. Alt +F11 to open VB
editor and double click 'This workbook' and see if there are any macros
redirecting the workbook to open on a certain sheet.

Mike

"Hatleydell" wrote:

I have a multi-spreadsheet workbook which I share with other users. When I
save and close in one spreadsheet (ie this week's) and then re-open, it
doesn't take me back to where I was when I saved it.