Active sheet in workbook

Hi,

I have a small problem, and don’t know how to solve it.
I am setting active sheet index (workBook.Worksheets.ActiveSheetIndex = index;), but the tab on bottom is hidden:

I want this:
grafik.png (699 Bytes)

I get this:
grafik.png (569 Bytes)

Here are both workbooks:
Tab_Visible_Hidden.zip (15.6 KB)

I think the problem is the following:
grafik.png (4.2 KB)

grafik.png (5.0 KB)

Many thanks in advance.

@sabrinaluedtke,

Thanks for the template files and screenshots.

I think you got to use the following line of code to make the first tab visible as per your needs:
e.g
Sample code:

workBook.Settings.FirstVisibleTab = 0;

Let us know if you still find the issue.

Works like a charm, thank you.

@sabrinaluedtke,

Good to know that your issue is sorted out by the suggested line of code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.