| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Focus back from modeless userform to sheet
Using Excel 2002.
I have a modeless userform that I can make pseudo-minimised with code from the form. It changes the height and width and top and left of the form, nothing else. After this I want to put the focus in the worksheet. I have seen many postings about this and they say that: AppActivate Application.Caption ActiveCell.Activate Should do the trick. Unfortunately it doesn't. Is there any other way to put the focus back in the worksheet? Thanks for any advice. RBS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modeless userform | New Users to Excel | |||
| Hide/Show modeless userform when activating/deactivating workbooks | Excel Programming | |||
| Must be a way to force focus back to sheet instead of UserForm - isn't there? | Excel Programming | |||
| How to set focus back to sheet after showing a user form | Excel Programming | |||
| How to set focus back to sheet after showing a user form | Excel Programming | |||
Threaded Mode
