Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ADDING/DELETING SHEET Without losing focus? | Excel Discussion (Misc queries) | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Adding a new sheet (no focus) | Excel Programming | |||
Change focus from Userform back to Sheet | Excel Programming | |||
Focus back from modeless userform to sheet | Excel Programming |