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

[Guest]

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

 

[Harald Staff]

Hi

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

HTH. Best wishes Harald

 

[Don Guillett]

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

 

[Ron de Bruin]

Hi Harald

She shows the sheet that was active when you last saved it

Now I know for sure that I am not gay
Excel is a woman <vbg>