how do i save file to show current worksheet

  • Thread starter Thread starter Hatleydell
  • Start date Start date
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.
 
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
 

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

excel auto jump worksheets when open 2
worksheet protection 3
How write Macro to save worksheet to a RELATIVE address 9
Have error condition "Too Many Different Cell Formats" 1
Save As with Different Version Name 3
Macro - save to current location vs excel default location 0
Can I save a worksheet as a picture? 3
How can I convert MBOX to MSG in Bulk with attachments? 1

Back
Top