how do i save file to show current worksheet

H

Hatleydell

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.
 
M

Mike H

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
 
M

MartinW

Hi,

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

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 to 2003 formatting troubleshooting 1
Opening to the "wrong" worksheet 2
worksheet protection 3
Can I save a worksheet as a picture? 3
File Save and File Save As are "gray" 1
How write Macro to save worksheet to a RELATIVE address 9
excel auto jump worksheets when open 2
Autofilter set to "SHOW ALL" on open for a protected worksheet 10

Top