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
|