Why do the sheet tab move to the very left?

[Gunnar Johansson]

Hi there,

Were on earth could I get an answer on such an question like this, but in
this group?
What commands make excel behave like this?

I have a lot of code and I can't identify why one of the sheet tabs moves to
the very left when I activate it. Observe, the tab doesn't change the "tab
order", just the tab focus move to the left of the GUI in the bottom of
Excel. It's like if you have three sheet/tabs and drag the left wall of the
bottom scrollbar to the left until you just can see 1,5 tab. If you activate
on tab, it will be higlighted in a visual position. That does not occur if
you can see all tabs well. My problem is that it's like I when activate
sheet3 and it move to the left and the other two aren't visual but to the
left of the third tab.

I have a worksheet_activate event on the sheet, but I have that on others as
well and they doesn't behave like this. That should not be the whole part of
the problem, anyhow.

What commands make this happend?

/Regards
Gunnar Johansson

 

[Don Guillett]

It might be helpful if you copied/pasted the sheet activate code here for
comments

 

[Gunnar Johansson]

Thanks for the interest!
The code contain calls to other procedures etc - I belive it will be to much
to ask to have you reading through all code and I fear my explanations of
the code take away focus of the question and make you tired...

I'll try this way first - if someone know any commands, methods that make it
behave like this.

/Regards
Gunnar

 

[Mark]

Toolbar > Tools > Options> View
make sure the Sheet Tabs is checked