Opening the tab on which remained.

[rediffusion]

Well... for example, I remained on `Developer` tab. I сlosed the book, started it and with opening `Developer` tab! Is it possible?

 

[Fluff]

Did you save the workbook before closing?

 

[rediffusion]

Did you save

Yes i saved.

 

[connor19]

i think it will depend on what tab you had before you close it and save

 

[Fluff]

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_]

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]

Excellent point Steve.

 

[rediffusion]

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?

Yes yes `RIBBON`

 

[Fluff]

That I have no idea about, I simply use the keyboard shortcuts.

 

[Steve_]

Yes yes `RIBBON`

I would start here...

https://www.mrexcel.com/forum/excel-questions/1052325-activate-ribbon-tab-without-xml-api-calls.html


I have not yet tested that code, but he is typically a reliable poster.