Focus sheet

[Max Potters]

Hi,

I have a little piece of code which selects another sheet, but while doing
this the focus on the sheet disappears, i.e. the blue bar you see on top of
Excel turns into vague blue, while normally this is deep blue. I tried to
use the .Select and .Activate statement, but none of these work.

I must say that I use a userform to let someone type in a password, and when
it's correct, it selects the othersheet (userform hides using the .Hide). I
don't know if this has anything to do with it, but I would like your help.

Thanks
Max

 

[Ron de Bruin]

Hi max

Try to use this after the .Hide
AppActivate Application.Caption

 

[Tom Ogilvy]

do you have

application.ScreenUpdating = False

in your code.

This might be the source of the problem if you do. Try setting it to true.

 

[Max Potters]

I tried both of your comments, but it still doesn't help. Do you have
another solution?

Btw, if i go from sheet1 to sheet2 (this happens without a userform) the bar
is deep blue, so the focus is ok.

Max