Opening the tab on which remained.

rediffusion

Board Regular
Joined
Apr 24, 2019
Messages
60
Well... for example, I remained on `Developer` tab. I сlosed the book, started it and with opening `Developer` tab! Is it possible?
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,474
Office Version
  1. 365
Platform
  1. Windows
Did you save the workbook before closing?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,474
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Unless you have some code that runs on opening, the sheet that was visible when you last saved, will be visible when opening the workbook.
 

Steve_

Board Regular
Joined
Apr 28, 2010
Messages
167
Well... for example, I remained on `Developer` tab. I сlosed the book, started it and with opening `Developer` tab! Is it possible?


When you say "tab" are you referring to the your Sheet tabs at the bottom?

Or are you talking about your RIBBON tabs at the top?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,474
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Excellent point Steve.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,474
Office Version
  1. 365
Platform
  1. Windows
That I have no idea about, I simply use the keyboard shortcuts.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,273
Messages
5,527,712
Members
409,784
Latest member
AdamPriest

This Week's Hot Topics

Top