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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0
Access Lock File .LACCDB / Now shows as a notepad file 0
I have lost 6 months work, how can i get my file back 1
External cell reference between two excel worksheets both in One Drive 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Suddenly Save and Save as greyed out in Excel 2003 0

Top