how do i get excel to open to the last worksheet used in a work b.

W

wngsee

When I open a workbook with tabs my screen do not show the last tab used but
shows a muck eairler tab used. I would like to go directly to the last tab
used when I open the work book
 
H

Harald Staff

Hi

She shows the sheet that was active when you last saved it. Save before
close.

HTH. Best wishes Harald
 
D

Don Guillett

Save the workbook at that point and make sure you don't have a workbook_open
or auto_open that changes it.
 

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

Top