Thread: Focus sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Potters Max Potters is offline
external usenet poster
 
Posts: 43
Default Focus sheet

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