Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restore Excel Application Window after proccesing ...
Hello gurus !
I have interesting question for you (and it is equal to my current nightmare :-). I'm oppening Lotus Notes PickList window from Excel VBA, check next code lines: Application.WindowState = xlMinimized Set Collection = workspace.PickListCollection(3, True, MyServer, MyDbName, MyView, MyTitle, MyPrompt) My problem is, that I'm not able to restore (better say to put to foreground) Excel after Lotus Notes PickList window is closed. Could you please help me, how to return focus back to Excel ? Thank you all in advance ! Vlado Sveda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restore Excel Application Window after proccesing ...
place the following line when you want excel to appear again
application.windowstate = xlmaximized 'can use xlnormal if you don't want the window maximized I hope it is that easy! -- JNW "Vlado Sveda" wrote: Hello gurus ! I have interesting question for you (and it is equal to my current nightmare :-). I'm oppening Lotus Notes PickList window from Excel VBA, check next code lines: Application.WindowState = xlMinimized Set Collection = workspace.PickListCollection(3, True, MyServer, MyDbName, MyView, MyTitle, MyPrompt) My problem is, that I'm not able to restore (better say to put to foreground) Excel after Lotus Notes PickList window is closed. Could you please help me, how to return focus back to Excel ? Thank you all in advance ! Vlado Sveda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, function window has gone. how can I restore | Excel Discussion (Misc queries) | |||
How do I open a new window for each excel application? | New Users to Excel | |||
How to set Excel to open a new window for each application | Excel Discussion (Misc queries) | |||
How do I restore the cell content window on my toobar? | Excel Discussion (Misc queries) | |||
How do I set up Excel to open a new instance/application window w. | Excel Discussion (Misc queries) |