Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form window too small - Help needed
Hi everyone.
i don´t know what is the error but sometimes when i open the workbook the form shows in a very small window....centered in the screen but like a minimized workbook. the only thing i do to show the form is this piece of code: sub workbook_open() Application.DisplayFullScreen = True form.Show vbModeless end sub Please help me i´ve tried many things but this never happen to me. the worst is that the application runs over and over and only sometimes this happens.i must put this application in the enterprise network,but with this bug........ thanks in advance Miguel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form window too small - Help needed
The userform looked fine when I tested in xl2003.
But maybe you wanted this: Application.WindowState = xlMaximized Instead of the .displayfullscreen line. Liedson31 wrote: Hi everyone. i don´t know what is the error but sometimes when i open the workbook the form shows in a very small window....centered in the screen but like a minimized workbook. the only thing i do to show the form is this piece of code: sub workbook_open() Application.DisplayFullScreen = True form.Show vbModeless end sub Please help me i´ve tried many things but this never happen to me. the worst is that the application runs over and over and only sometimes this happens.i must put this application in the enterprise network,but with this bug........ thanks in advance Miguel -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form window too small - Help needed
thanks Dave for your reply..
it seems that a mix between windowstate and then the displayfullscreen is working perfectly....the window shows until know always in fullscreen....what i wanted... i used in other applications the windowstate function but in this case i really wanted the fullscreen view of the form and know i think is working fine...... thanks very much Miguel "Dave Peterson" wrote: The userform looked fine when I tested in xl2003. But maybe you wanted this: Application.WindowState = xlMaximized Instead of the .displayfullscreen line. Liedson31 wrote: Hi everyone. i don´t know what is the error but sometimes when i open the workbook the form shows in a very small window....centered in the screen but like a minimized workbook. the only thing i do to show the form is this piece of code: sub workbook_open() Application.DisplayFullScreen = True form.Show vbModeless end sub Please help me i´ve tried many things but this never happen to me. the worst is that the application runs over and over and only sometimes this happens.i must put this application in the enterprise network,but with this bug........ thanks in advance Miguel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Windows XP Pro Ed._Desktop window at startup is too small | Excel Discussion (Misc queries) | |||
How I can I open a small window within window | Excel Discussion (Misc queries) | |||
Want to see ALL labels in small window | Charts and Charting in Excel | |||
Small application needed | Excel Programming | |||
Running DOS .bat file from Shell in a small vs. full window | Excel Programming |