Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms fill screen whatever resolution
Hi,
I am designing a system that I want to look like it is not an Excel spreadsheet. I would therefore like the UserForms to fill the screen. I can do this manually but if somebody else has a different screen resolution it doesn't fit right. Is there a way of doing this automatically? Can you use an if to determine screen resolution? Thanks in advance for any help you can offer. JohnP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms fill screen whatever resolution
Not the way to go, in my opinion. Never try to take over the entire screen.
Better to use Application.Visible = False to make Excel disappear. Just be sure to make it visible again when your form closes. -- Jim "JohnP" wrote in message ... | Hi, | | I am designing a system that I want to look like it is not an Excel | spreadsheet. I would therefore like the UserForms to fill the screen. I can | do this manually but if somebody else has a different screen resolution it | doesn't fit right. | | Is there a way of doing this automatically? | Can you use an if to determine screen resolution? | | Thanks in advance for any help you can offer. | JohnP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms fill screen whatever resolution
Hi Jim,
I just added that code in and closed and saved it despite your wanring. It now closes as soon as it opens. Is there a way around this. I have tried to Ctrl Break as it opens. Please help!!!! "Jim Rech" wrote: Not the way to go, in my opinion. Never try to take over the entire screen. Better to use Application.Visible = False to make Excel disappear. Just be sure to make it visible again when your form closes. -- Jim "JohnP" wrote in message ... | Hi, | | I am designing a system that I want to look like it is not an Excel | spreadsheet. I would therefore like the UserForms to fill the screen. I can | do this manually but if somebody else has a different screen resolution it | doesn't fit right. | | Is there a way of doing this automatically? | Can you use an if to determine screen resolution? | | Thanks in advance for any help you can offer. | JohnP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms fill screen whatever resolution
Are you sure it closed, or just not visible. Us Alt + F11 to see if the VB
editor will open when the screen goes blank. Another method is to open it as a second workbook when another is open, then access the VB editor to get to your code and modify it. "JohnP" wrote: Hi Jim, I just added that code in and closed and saved it despite your wanring. It now closes as soon as it opens. Is there a way around this. I have tried to Ctrl Break as it opens. Please help!!!! "Jim Rech" wrote: Not the way to go, in my opinion. Never try to take over the entire screen. Better to use Application.Visible = False to make Excel disappear. Just be sure to make it visible again when your form closes. -- Jim "JohnP" wrote in message ... | Hi, | | I am designing a system that I want to look like it is not an Excel | spreadsheet. I would therefore like the UserForms to fill the screen. I can | do this manually but if somebody else has a different screen resolution it | doesn't fit right. | | Is there a way of doing this automatically? | Can you use an if to determine screen resolution? | | Thanks in advance for any help you can offer. | JohnP |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms fill screen whatever resolution
Set macro security on medium and then disable them at the prompt when you
open your workbook. Then fix your code. -- Jim "JohnP" wrote in message ... | Hi Jim, | | I just added that code in and closed and saved it despite your wanring. It | now closes as soon as it opens. Is there a way around this. I have tried to | Ctrl Break as it opens. | | Please help!!!! | | "Jim Rech" wrote: | | Not the way to go, in my opinion. Never try to take over the entire screen. | | Better to use Application.Visible = False to make Excel disappear. Just be | sure to make it visible again when your form closes. | | -- | Jim | "JohnP" wrote in message | ... | | Hi, | | | | I am designing a system that I want to look like it is not an Excel | | spreadsheet. I would therefore like the UserForms to fill the screen. I | can | | do this manually but if somebody else has a different screen resolution it | | doesn't fit right. | | | | Is there a way of doing this automatically? | | Can you use an if to determine screen resolution? | | | | Thanks in advance for any help you can offer. | | JohnP | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the screen resolution in VBA | Excel Programming | |||
Screen Resolution | Excel Programming | |||
Screen Resolution | Excel Programming | |||
Screen resolution | Excel Programming | |||
VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN | Excel Programming |