excel will not open in right worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open one of my workbooks with multiple spreadsheets, it opens to the
last sheet I had open, then switches to the sheet beside it. How can I get it
to open and stay on the last sheet I had open?
 
bf

Perhaps you have some event code in ThisWorkbook that switches sheets?

Hit ALT + F11 to get to the VB Editor.

Select your workbook/project and expand Microsoft Excel Objects.

Double-click on ThisWorkbook. Any code in there?


Gord Dibben Excel MVP
 
You must log in or register to reply here.

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 shortcut options 0
Excel Excel spreadsheets opening at top instead of bottom. 4
Merge Multiple workbook sheets into one workbook 0
Open a excel workbook always on the same sheet 1
VB Code for Excel 2
Open Workbook on Specific Worksheet 3
Issue is facing on Word 2016 -{EMBEDED Excel.Sheet.12} 0
Cannot copy worksheet to another file 2

Back
Top