how do i save file to show current worksheet
 

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.

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.

how do i save file to show current worksheet
 

Hi,

It should open to wherever the active cell was when it was last saved.

HTH
Martin



"Hatleydell" wrote in message
...
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.